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