Pro SQL Server 2012 Reporting Services

CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0

Figure 13-54. Report objects available from the Insert tab

Next, drag the following four fields from the Emp_Svc_Cost dataset that was created with the data

source, onto the Matrix control in the report: BranchName, Service_Type, Visit_Visit_Count, and

Estimated_Cost. Add BranchName and Service_Type to the Rows area and Visit_Count and

Estimated_Cost to the Data area. When we added Visit_Count to the Data area, Report Builder added a

header automatically. We don’t want it to be labeled with Visit Count, so select the textbox and then hit

Delete to remove it. At this point, the report should be similar to the layout depicted in Figure 13-55.

Notice that the Sum functions were automatically applied to the fields dragged to the Data area.

Figure 13-55. Report Matrix with fields added