Pro SQL Server 2012 Reporting Services

CHAPTER 6  BUILDING REPORTS

Figure 6-7. Report output with formatting

The EmployeeServiceCost_Format.rdl report in the Pro_SSRS project has the formatting elements

applied.

Adding Subtotals

Having subtotals at each grouping level makes the report much easier for the user to read. This is

especially true if the report has interactive drill-down features, as yours will have.

Adding subtotals to the groups is as easy as copying and pasting or entering the field value

expressions— in this case, =Sum(Fields!Visit_Count.Value) and =Sum(Fields!Estimated_Cost.Value)—to

the upper level grouping cells in the report. For this report, you have defined a group for the

Employee_Name field in the detail row. This forces the report to calculate the sums of the

Estimated_Cost and Visit_Count fields for each employee. For this report, this is all that is required, but

for many other reports you will be creating, you will need to include the detail records for a more

granular analysis.