Format Cells dialog box: Border tab

The border settings define how the borders are displayed for the selected object. For example, the object could be the metric headers of a report or the subtotal values in a report.

Use defaults check box

The Use defaults check box is selected, which retains the default border style. Once this option is selected, all the other options on this tab are unavailable. To make a change to one of the items on this tab, you must clear the Use defaults check box.

To format the borders of cells on a report

To remove the entire border, click None in the Presets area. You do not have to select a Line Style, Line Color, and so on.

Format the line to use as the border:
- Line Style: Click the style of line to use as the border. Your choices are No Line, Dashed, Dotted, Hair, Thin, Double, and Thick.
  - The Hair line style cannot be displayed in reports viewed in MicroStrategy Web.
  - Some line styles do not display in MicroStrategy Developer. They are visible if you apply and save them, then open the report in MicroStrategy Web.
- Line Color: Click the arrow and select the color to use for the border.
Select which borders to apply the Line Style and Line Color to:
- To apply the formatting to the entire border, click Outline in the Presets area.
- To apply the formatting to specific sections of the border, click the Top Border, Bottom Border, Left Border, and/or Right Border buttons.
  
  The only border formatting that is visible in MicroStrategy Developer is formatting applied to all four borders (by clicking None or Outline in the Presets area). For more complex formatting combinations, such as applying bold to top and bottom borders only, or applying green to left and right borders only, you can apply and save these changes in MicroStrategy Developer, and then open the report in MicroStrategy Web to see the formatting.

To display the right border of a total or subtotal row, select the Use Defaults check box. This allows the column formatting for borders to override any row-level borders applied to the subtotal values.

Click OK.

A preview of your selections is displayed in the Border area.