Lesson 6: Applying Formatting and Style

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

There are additional tasks that you can perform to clean up the report and make it easier to read.

The OrderDate field displays date and time information by default. You can add formatting to display only the date.

1. Right-click the cell with the OrderDate field expression and then click Properties. The Textbox Properties dialog box appears.

2. Open the Format tab and click the browse button (indicated by the ellipses button label) to open the Choose Format dialog box.

3. For Format, select Standard, select Date, and then select the third example on the list (short date).

4. Click OK to close the Choose Format dialog box, and then click OK again to close the Textbox Properties dialog box.

The TotalDue field displays a general number. Add formatting to display the number in currency format.

1. Right-click the cell with the TotalDue field expression and then click Properties.

2. Open the Format tab and click the browse button (indicated by the ellipses button label) to open the Choose Format dialog box.

3. For Format, select Standard, select Currency, click OK, and then click OK again to close the Textbox Properties dialog box.

You can also add style to the table headers to differentiate them from the rows of data in the report, and adjust the widths of the columns.

1. Click the table so that column and row handles appear above and next to the table.

2. Select the row handles of the first, second, and fourth rows (the row containing column header labels, the group header row, and the group footer row) and then click the Bold (B) button on the formatting toolbar.

   Note

   To select multiple items, hold down the CTRL key and click on each item.

3. Point to the line between column handles so that the cursor changes into a double arrow. Drag the columns to size.

You have successfully applied formatting that applies a style to column headers and changes how date and currency values are formatted. Next, you will preview the report to view your changes. See Lesson 7: Publishing the Updated Report.

Applying Style Properties to Report Items
Formatting Numeric and Date Values in a Report

Tutorial: Adding Grouping, Sorting, and Formatting to a Basic Report

Getting SQL Server 2008 Assistance