Pro SQL Server 2012 Reporting Services

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

3. Select the title in the body of the report and drag it into the header section


4. With the report title selected, click on the View tab and put a check in the
   Properties option to show it.


5. Change the FontSize property to 14pt rather than the default 20pt. Resize the
   header textbox to be slightly larger than the title. This will give us some room
   in our header to show one more field.


6. Drag the User ID build-in field over to the right of the report title. This will
   create a textbox with the User ID field value. You can right align this new
   textbox make it italicized and add bold formatting.

You can easily add more formatting, or report beautification as I like to call it, but at this point, the

report should look like Figure 13-59 when previewed.

Figure 13-59. Preview of report with execution time and title

For a final touch, you will add totals to the report. This is easily accomplished by clicking back in the

design area and selecting both of the cells in the Data region, Visit_Count, and Estimated_Cost. You can

select both at once by selecting the first cell and, while holding down the Shift key (or CTRL key),