Adding Graphical Elements

You can use rectangles, lines, and images to create visual effects within a report. Rectangles and lines are not associated with data. Images can either be static or based on data in a database.

Lines and rectangles can be used for visual effect. A rectangle can also used be used as a container for other items. When you move the rectangle, the items that are contained within the rectangle move along with it.

When using rectangles to contain report items, consider how the items will be affected as a whole during report rendering. Report items that contain repeated rows of data (for example, tables) will expand to accommodate the data that is returned by a query, and this affects the positioning of other items in the rectangle. A table will push items down if they are positioned below the data region. To anchor an item in place, you can place the report item inside of a rectangle that has an upper edge above the lower edge of the table.

Adding a Report Border

You can add a border to a report by adding borders to the headers, footers, and report body. In the header, add a left, top, and right border. In the body, add a left and right border. In the footer, add a left, bottom, and right border. If you do not use headers in your report, you can place borders around just the report body.

If you add a report border that appears on the page header and footer, do not suppress the header and footer on the first and last pages of the report. If you do, the border may appear cut off at the top or bottom of the first and last pages of the report.

See Also


How to: Add a Line (Report Designer)
How to: Add a Rectangle (Report Designer)


Designing the Report Layout

Help and Information

Getting SQL Server 2005 Assistance