CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0
Figure 13-62. Employee Service Cost by branch and patient state in design mode- Right-click on the Data Sources folder and select Add Data Source. Name the
data source Pro_SSRS, select Use a shared connection or report model and
click the Browse button to navigate to the Pro_SSRS data source under the
Pro_SSRS/DataSources folder. Click Open and then OK to save the data source. - Right-click on the Datasets folder and select Add Dataset. Name the data set
Emp_Svc_Cost_RB3 and select Use a dataset embedded in my report. Select
the Pro_SSRS as the data source to use and select the Query type radio button
to Stored Procedure. Select the Emp_Svc_Cost_By_Patient_State_RB3 stored
procedure and click OK to save your dataset. - Next, change the report title to Employee Service Cost by Branch and Patient
State. Resize the title textbox to fit the new title without wrapping to the next
line. - Right click on the report design surface, select Insert and then Matrix. This
adds a new Matrix report object to the report design pane. Drag the Matrix
toward the top left near the title. - Drag the Visit_Count field into the Data field and then drag the
Estimated_Cost field to the right of Visit_Count.