Column Formatting

You can customize the basic formatting of column headings and fields, using the Format Column dialog. To launch this window from the Report Viewer, Move your mouse over   and click Formatting...

The Format column dialog appears

 
From the Format Column dialog, you can format a column's headings or values, or apply conditional formatting to a column.

This section discusses how to apply formatting to column headings and values.

Column formatting options include:

• Text
• Font type, size, and style
• Background color
• Font color
• Text alignment

To customize your column formatting:

1. Run your report, so it opens in the Report Viewer.
2. Click the header or field of the column you want to format.
3. Move your mouse over and click Formatting...
4. To format a column's heading, click the Headings tab, and change the following options if needed:

• Heading text – Type new heading text to replace the current text.
• Font – Scroll through the menu to select a font.
• Size – Scroll through the menu to select a font size.
• Style – Click to select Bold, Italic, or Underlined text.
• Background Color – Click to open the background color picker, then click to select the background color.
• Font Color – Click to open the font color picker, then click to select the text color.
• Alignment – Click to select Left, Center, or Right alignment.

5. To format the text in a column's fields, click the Values tab, and change the following options if needed:

• Font – Scroll through the menu to select a font.
• Size – Scroll through the menu to select a font size.
• Background Color – Click to open the background color picker, then click to select the background color.
• Font Color – Click to open the font color picker, then click to select the text color.
• Alignment – Click to select Left, Center, or Right alignment.

6. Click OK.