Formatting the Cross-Tab
Change the background color of a dimension
- Select the dimension.
- Select the color from the Background Color drop down list.
- Click Next if you have finished customizing your Cross-Tab.
Create an Alias for a Dimension
You can create aliases to shorten long dimension names. This is useful when you plan on referring to a dimensions in conditional formatting formulas (GridRowColumnValue function).
- Select the dimension.
- Enter the alias name.
- Click Next if you have finished customizing your Cross-Tab.
Changing Grid Object Options
You can change the formatting of your grid objects using the check boxes associated with the following options:
- Show cell margins
- Indent row labels
- Repeat row labels
- Keep columns together
- Row totals on top
- Column totals on left
- Suppress empty rows
- Suppress empty columns.
Format grid lines
In the Format grid lines area you can define whether the lines show or not, as well as the color, style, and width.
- Click Format Grid Lines.
The Format Grid Lines dialog box appears.
- From the list, choose the description of the area where you would like the lines to appear, or click the appropriate area in the Format Grid Line diagram.
- Select the color, style, and width.
- Select the Draw check box to have your lines appear in the report.
- Click OK.
- Click Next.
The Chart tab appears.