Suppressing Cross-Tab data
This section provides you with the steps required to suppress data in your report. You can suppress:
- Empty rows and columns
- Row and column grand totals
- Subtotals and their labels.
To suppress empty rows and columns
- Right-click the blank top-left area of the Cross-Tab and select Format Cross-Tab from the shortcut menu.
The Cross-Tab dialog box appears.
- Click the Customize Style tab.
- Select either the Suppress Empty Rows or Suppress Empty Columns check box.
- Click OK.
Now, when you print the report, empty rows and/or columns will not appear.
To suppress row and column grand totals
- Right-click the blank top-left area of the Cross-Tab and select Format Cross-Tab from the shortcut menu.
The Cross-Tab dialog box appears.
- Click the Customize Style tab.
- Select either the Suppress Row Grand Totals or Suppress Column Grand Totals check boxes.
- Click OK.
To suppress subtotals and labels
If you have more than two groups in your Cross-Tab you can suppress the subtotal and label for one of them.
- Right-click the blank top-left area of the Cross-Tab and select Format Cross-Tab from the shortcut menu.
The Format Cross-Tab dialog box appears.
- Click the Customize Style tab.
- Click the field whose subtotal you want to suppress.
The Suppress Subtotal and the Suppress Label check boxes become active.
- In the Group Options area select the Suppress Subtotal check box.
- Click the Suppress Label check box to suppress the label associated with subtotal.
- Click OK.