Setting cross-tab display options
This section describes how to specify the following cross-tab options, as shown in Figure 2-12:
*
Select a measures header orientation.
*
Show or hide empty rows.
*
Show or hide empty columns.
*
Specify a character string to display in empty cells.
*
Enable page breaks for a large cross tab.
Specify the following locations to apply page breaks:
*
Specify a number of rows after which to apply a page break.
*
Specify a number of columns after which to apply a page break.
*
Specify where to display grand totals and subtotals, before or after the detail columns and rows.
Figure 2-12  
Setting cross-tab options
The following topics describe setting cross-tab options.
How to move a measure header
1  
Right-click an element in the cross tab. From the menu, choose Options.
2  
In Options, for Measure Header Orientation, select Horizontal or Vertical, as shown in Figure 2-13. Choose OK.
Figure 2-13  
Setting the measure header orientation
How to change the appearance of empty cells, columns, or rows
1  
Right-click a cross-tab element. From the menu, choose Options.
2  
In Options, complete the following tasks, as shown in Figure 2-14:
*
Select or deselect the following options:
*
Show empty rows.
*
Show empty columns.
*
In For empty cells, show, type a character string to display in empty cells.
Choose OK.
Figure 2-14  
Setting options for empty cells, columns, and rows
In this example, hyphens appear in the previously empty cells, as shown in Figure 2-15.
Figure 2-15  
Displaying hyphens in empty cells
How to set a page break
1  
Right-click the cross tab. From the menu, choose Options.
2  
In Options, to set page break options, select Enable Page Break. Then, provide values for the row interval and column interval after which to apply the page break, as shown in Figure 2-16.
Figure 2-16  
Setting page break options
Choose OK.
How to specify where grand totals and subtotals appear
1  
Right-click the cross tab. From the menu, choose Options.
2  
In Options, in Totals Display, select Before or After for each of the following options, as shown in Figure 2-17:
*
Display Grand totals on
Selecting Before displays the grand totals before the detail columns and rows. Selecting After displays the grand totals after the detail columns and rows.
*
Display Subtotals on
Selecting Before displays the subtotals before the detail columns and rows. Selecting After displays the subtotals after the detail columns and rows.
Figure 2-17  
Setting totals display options
Additional Links: Forums | Blogs | Support | Give Us Feedback | More...

Copyright Actuate Corporation 2012