Pro SQL Server 2012 Reporting Services

CHAPTER 3  INTRODUCTION TO REPORTING SERVICES DESIGN WITH SQL SERVER DATA TOOLS

2. You can use a shared dataset but in this example you will utilize a dataset
   embedded in the report. Choose Use a dataset embedded in my report option.


3. Now create a link between this dataset and the data source that we created
   earlier. Click the New button next to the data source drop-down box.


4. In the Data Source Properties window, name the data source Pro_SSRS and
   choose Use shared data source reference.


5. Click on the drop-down list box and select the Pro_SSRS shared data source
   that we created earlier.


6. Figure 3-8 shows the Data Source Properties windows with these settings. Click
   OK to save your settings.

Figure 3-8. Data source properties

Now that we have a link to our shared data source, we can point the dataset to our stored procedure.

In the Query Type section, change the default, Text, to Stored Procedure. In the Select or enter stored

procedure name textbox, input the name of your stored procedure, Emp_Svc_Cost, as shown in Figure

3-9. Finally, enter Pro_SSRS_DS for the name of the new dataset and click OK to complete the dataset

configuration.