Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Formatting a Report (Report Builder 1.0)

Formatting the items in your report makes the report look more attractive and enhances its readability. You can format the text boxes, the images, the fields in the report layout, and the data while in design mode.

Some items in your report are already pre-formatted for convenience; however, you can change the formatting already in place. In some instances, Report Builder automatically formats the information for you, for example, column heading text is automatically formatted as Bold, and every cell within the report layout has a cell padding of 2 points on each side. In other instances, the data source provides the formatting information for the contents of a field, for example, the person who designed the data source might assign a monetary format to fields that contain monetary values. In this case, when you drag the field to the design area, the monetary field displays placeholder data with a currency symbol and the appropriate number of decimal places as specified in the data source.

You can change formatting options by selecting the item you want to format and then using the Format dialog box or the Formatting and Borders toolbars to make your changes.

The formatting changes you make to the report are reflected in the design area. You do not need to run the report to see applied formatting.

Formatting Numerical Data (Report Builder 1.0)

Discusses how to format numbers and dates.

Aligning Data, Text, and Images (Report Builder 1.0)

Discusses how to align report data and text.

Formatting Data, Text, and Images (Report Builder 1.0)

Discusses how to format text options, such as font, font style, and size, within text boxes and the report layout, and how to format image data.

Formatting Borders, Lines, and Gridlines (Report Builder 1.0)

Discusses how to add borders and gridlines to text boxes and the report layout.

Applying Background Colors (Report Builder 1.0)

Discusses how to fill text boxes and areas of the report layout with background colors.

Formatting within the Data Source

Differences between computer culture and data source culture settings can cause confusing behavior when designing and running a report.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.