Formatting row and column headers and cells

Analysts can apply a number of formatting characteristics to a report they have executed. However, the report's designer can apply a broader range of formatting options to a report, so that users can more effectively understand the data displayed on the report, or to simply achieve a pleasing and easy-to-read look. Formatting options available to analysts are described in Formatting a Report.

To format row and column headers and cells

1. In MicroStrategy Web, run the report that you want to format.

2. From the Format menu, select Advanced Grid Formatting.

   If DHTML is disabled, click Go.

3. From the first drop-down list at the top of the dialog box, select the area of the grid to change.
4. From the second drop-down list at the top of the dialog box, select whether to format the All, Header, Values, Subtotal Names, or Subtotal Values of that area of the grid.

5. Select one of the following tabs to access formatting options for your report.

   • Font: Change the font and color of letters and numbers in the report, and change the background by applying gradients and other effects.

     To change cell background (fill) color:

     • If DHTML is enabled, use the Fill Color option on the Color and Lines tab.
     • If DHTML is disabled, use the Fill Color drop-down list on the Font tab.
   • Number: Specify a number format for values. For example, you can ensure that certain metric values are displayed as percentages.
   • Alignment: Specify how values and text are aligned within cells on the grid report.

   • Color and Lines: Change the formatting of lines in your grid report, such as cell borders.

     To format cell borders:

     • If DHTML is enabled, use the Borders options on the Color and Lines tab.

     • If DHTML is disabled, use the Borders tab in the Format panel.

6. Click Apply.