Pro SQL Server 2012 Reporting Services

(sharon) #1
CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0

Figure 13-51. Creating a new data source



  1. 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.

Free download pdf