Now that you have created a Share Data Source, it's time to add some data to your project. In this post I will explain Shared Datasets and demonstrate how to add a one to your project.
As with a data source, you can create an embedded or shared dataset. The primary advantage to creating a shared dataset is that it can be used by all reports in a given Reporting Services project. In addition, you can deploy a shared dataset so that it is exposed to end-users via SharePoint or the Report Manager. I will explain this in later posts.
Regardless of the type of dataset, Shared or Embedded, the concept is still the same. A dataset specifies the data that will be used from a Data Source. The dataset includes a query that provides a list of fields that can be used in your report. If you plan on creating a shared dataset you must create a shared data source first. Visit the following link for more details:
Before you walk through the following steps I have prepared several stored procedures that will be used throughout this series. The most recent backup of the ContosoSchoolsDW includes them, however if you obtained an earlier version you will need to download and execute this query.
In the next post, SSRS 101 – Creating your first Report and Adding Data Sources and Datasets, I will explain how to create a report and add a data source and data set.
Talk to you soon, Patrick LeBlanc, Microsoft, Technical Solutions Professional SQL Server and Business Intelligence
<p>Thank you for this series of articles, Patrick. Is this one available yet - SSRS 101 – Creating your first Report and Adding Data Sources and Datasets? My shared data source exists as I am using a solution file already created with other reports, and I first created my report using an embedded data source, and now I want to change it to use the shared one. Since I cannot find how to do that poking around in Visual Studio, I am thinking this next article will be a big help. Thanks.</p>
<p>Marlene I will publishing new content on both topics soon. </p>