CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0- Finally, reset the report title by clicking the Click to add title textbox at the top
of the report. Set the report title to Service Type Estimated Cost by Branch and
change the width of the textbox to be approximately 5 3/4 inches.
When you are done making all of these changes, the report should look like Figure 13-58.Figure 13-58. Report with title added
Finally, you have probably noticed the [&ExecutionTime] in the report footer. This is added by
Report Builder 2.0 by default. If you wish to delete it, just select it and hit delete. However, if you want to
add more built-in fields to the footer or header sections, just expand the Built-in Fields folder in the Data
window to see your options. You will see ExecutionTime, PageNumber Report Folder, Report Name,
Report Server URL, Total Pages, User ID, and Language as possible selections. For our example, we are
going to add a header to our report and add the User ID to it along with our report title.
- While in design mode, click on the Insert tab.
- Click on Header and then Add Header. Resize it to be about ½ of an inch in
height.