CHAPTER 4 LAYING OUT A REPORTThe starting-point report for this section is called Rectangle Start.rdl. It’s available in the Pro_SSRS
project in the Source Code/Download area for the book on the Apress site.
To begin, open the Rectangle Start.rdl report, and follow these steps to add a rectangle to the
entire detail row:
- Drag a Rectangle data region from the Toolbox into the extended detail row in
the Rectangle Start report. - Drag two fields, Visit_Count and Estimated_Cost, from the emp_svc_cost
dataset into the detail area. Place them vertically so that the Visit_Count field
is above the Estimated_Cost field. Notice that SSRS automatically assigns the
Sum aggregate function to the fields. - Drag two textboxes from the Toolbox into the rectangle to the left of the two
fields you just added. The textboxes, which can contain expressions or literal
strings, serve as labels. Inside the textboxes, type Visit Count and Estimated
Cost, respectively. - Add formatting to the textboxes by selecting both with shift-click and then
setting the text color property to Firebrick and the font size to 12 point. You
will also make the Estimated_Cost and Visit_Count fields bold. You can find
these settings on the standard formatting toolbar or in the Properties window.
When complete, the report layout will look like it does in Figure 4-17.