CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0
Figure 13-51. Creating a new data source
- Right-click on the new Pro_SSRS data source in the Report Data pane and
select Add Dataset. Name the dataset Emp_Svc_Cost and set the Query type to
Stored Procedure. If prompted for login credentials, enter the appropriate
login details. Then in the Select or enter stored procedure name drop down,
select our Emp_Svc_Cost stored procedure. Figure 13-52 displays the Data
Properties window. Click OK to save the Emp_Svc_Cost dataset.