Formatting Crosstabs

Introduction

The following custom formatting options are available for crosstabs:

• font style, color, and alignment – of the cell values

• width and height – of columns and rows

• background color – for columns and rows, or for the entire crosstab

• border color and thickness – around the cells in specific columns and rows

• number and currency format – for cell values displaying numeric or date/time data
   

In addition, you can show or hide headers on crosstabs. Unlike other tables, crosstabs do not automatically display headers with the names of the dimensions, details, and measures they include. You can choose to show or hide headers that display the labels of the dimensions, measures, and details of the cell values.

The following section of this guide tells you how to:

• format a crosstab

• display headers in a crosstab

Format a crosstab

To format a crosstab:

1. Verify you are on the Format tab.
   If the Format tab is not visible, check the More Report Options check box.
   A document can contain multiple reports. The name of the selected report appears in the Current report dropdown list box.
   

2. Leave the displayed report selected.
   Or
   Select a different report by clicking the arrow next to the Current report dropdown list box, and then select a different report from the list.
   The Result Preview pane displays the structure of the crosstab.
   

3. To select the area of the crosstab that you want to format, click Columns, Rows, or Body on the Result Preview pane.

4. The following illustration shows how the Columns, Rows, and Body areas of the Result Preview pane correspond to the crosstab viewed in results mode.
   
   The object(s) included on the selected part of the crosstab appear on the pane to the right of the Result Preview pane. Each object represents a type of data included on the selected columns, rows, or body.
   

5. Click the object corresponding to the data you want to format.
   For example, if you want to format how the values of each quarter (Q1, Q2, and so on) display on the crosstab columns, click the [Quarter] object.
   If you want to apply the same formatting changes to all of the displayed objects, select one object now to specify the formatting. You can globally apply the formatting changes to all of the objects in step 7.

6. Specify the custom formatting options you want to apply.
   
   The following table will help you choose the appropriate options:
   

7. If you want to apply the formatting changes to all the objects in the selected column, row, or body click Apply All.
   You can apply other modifications to the document using the tabs on the HTML Report Panel or run the report now to view the results.

8. Click Run, if you are generating the results for the first time.
   Or
   Click Apply, if you have already generated the results once.

Display headers in a crosstab

To display headers in a crosstab:

1. Verify you are on the Format tab.
   If the Format tab is not visible, check the More report options check box.
   A document can contain multiple reports. The name of the selected report appears in the Current report dropdown list box.

2. Leave the displayed report selected.
   Or
   Select a different report by clicking the arrow next to the Current report dropdown list box, and then select a different report from the list.

3. Click the Report area in the Result Preview pane.
   
   The Report Format options appear to the right of the Result Preview pane.
   You show or hide headers in the Crosstab section of the options.

4. If you want to display the headers, select the Show object name check box.
   Or
   If you want to hide the headers, .unselect the Show object name check box.
   

5. Click Run, if you are generating the results for the first time.
   Or
   Click Apply, if you have already generated the results once.