Nov 11, 2015

Create Shared Datasource SSRS

In this post, we will see how to create a Shared Data Source in SSRS.

Data Source contain the information necessary to retrieve the data from the relational database to render the reports. If a data source is not shared, it is stored inside a report and can not be used by other reports.

In general, we need to have a data source that can be used in all the reports in the same project. Such data sources are called as shared data source.

Now let's walk through how to create a shared data source

Prerequisites
  • SQL Server 2012 with Reporting Services
  • AdventureWorks Database

NOTE: We would be using AdventureWorks Sample Database which is shipped with SQL Server 2012 Enterprise Edition. If you have Express Edition you have to download it.  Download here.


Step 1:  Open SQL Server Data Tools and create a new Project  Business Intelligence > Report Server Project and name it as SSRS-Tutorials

Create Project


Step 2: Right Click Shared Data Source, then Add New Data Source. A new pop pup window will appear to configure Data Source Properties. Change the name of Data Source to AdventureWorks

Data Source

Step 3: Click on Edit, a new pop up window will appear to configure Connection Properties like Server Name, Authentication and Database

Connection Properties

Step 4: Click OK twice to close the popup windows and Shared Data Source AdventureWorks is created.

Shared Data Source

    Choose :
  • OR
  • To comment
No comments:
Write Comments

Probabilmente come studente universitario ti troverai a scrivere una o più tesi per il tuo analogo esame di fine carriera. Ma di cosa si tratta in particolare? Scopriamo quali sono i pro dei tool per riscrivere testo che troverai online. Per strumento di parafrasi si intende un tool online che si occupa di parafrasare in maniera immediata frasi oppure interi paragrafi. Questa attività si svolgerà interamente su internet e non lascerà alcuna traccia di plagio