Partilhar via


Working with Text Boxes (Report Builder)

A text box is a movable, resizable container for text that appears in a report layout. Text boxes can be moved anywhere within the design area. The text within a text box wraps automatically; however, you need to adjust the size of the text box to accommodate the text. Text boxes can only contain text and special effects cannot be applied; however, the text box and its contents can be formatted. Every Report Builder report layout contains the following two text boxes by default: Title and Filter description. The table report layout also contains a Total rows textbox. In addition, you can add an unlimited number of additional text boxes to your report and move them anywhere within the design area. Hyperlinks cannot be added to a text boxes.

Title Text Box

By default, every report layout has a Title text box for you to type a title for the report. The text box is positioned above the main body of the report but you can move it to another location within the design area. By default, text is displayed as Arial, 18 point, bold, and left-aligned, but you can change these format options.

Total Rows Text Box

The Total rows text box only appears in a table report layout. The contents of the text box are automatically updated to display the number of rows returned in the table when the report is run. The text box is positioned below the table by default but you can move or delete it. The text within the box cannot be changed but you can change the formatting.

Filter Description Text Box

The Filter description text box appears in every report layout. The contents of the text box are automatically updated to display a restatement of the filter when you apply a filter to the report. The text box is positioned at the bottom of the report layout by default but you can move or delete it. The text within the box cannot be changed but you can change the formatting. If you do not apply a filter to your report, the filter description does not appear in the report when it is run.

See Also

Tasks

How to: Add, Move, Resize, or Delete a Text Box (Report Builder)
How to: Format the Contents of a Text Box (Report Builder)

Concepts

Working with Report Layouts (Report Builder)
Formatting a Report (Report Builder)
Working with Data (Report Builder)
Working with Images

Help and Information

Getting SQL Server 2005 Assistance