CHAPTER 3 INTRODUCTION TO REPORTING SERVICES DESIGN WITH SQL SERVER DATA TOOLSFigure 3-9. Dataset properties
When you click OK, a few things happen behind the scenes in the Report Data window. A data
source called Pro_SSRS is created under the Data Sources folder and a dataset named Pro_SSRS_DS is
created under the Datasets folder. This dataset is populated with the available fields from the stored
procedure. At the same time, BIDS creates all of the parameters that the stored procedure accepts. You
can’t see the actual data at this point, but you can right-click the dataset and select Query... to bring up
the default generic query editor where you can execute the stored procedure. At execution time, you are
prompted for any parameters that have been defined by the stored procedure; you must supply the
parameter values before data is returned. In the case of this stored procedure, define five parameters:
@ServiceYear, @ServiceMonth, @BranchID, @EmployeeTblID, and @ServicesLogCtgryID. The available
default values for the parameters, when the stored procedure is executed in the Report Data box, are