Export (0) Print
Expand All

Lesson 6: Applying Formatting and Style

SQL Server 2005

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.

Choose Date Format 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.

Choose Currency Format 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.

    ms170036.note(en-US,SQL.90).gifNote:
    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.

Resize arrows for column in table data region

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.

Community Additions

ADD
Show:
© 2014 Microsoft