Crosstab Properties dialog

The dialog appears when you right-click a crosstab and select Properties from the shortcut menu. It helps you to specify the properties of the crosstab and contains the following tabs:

OK

Applies the settings and closes this dialog.

Cancel

Cancels the settings and closes this dialog.

Help

Displays this help document.

General tab

This tab shows some general information of the crosstab. See the tab.

Name

Specifies the display name of the crosstab, which will be shown on the shortcut menu of the crosstab.

Horizontal Alignment

Specifies the horizontal justification of the crosstab. Choose an option from the drop-down list.

Background

Specifies the background color of the crosstab.

To change the color, click the color indicator to select a color, or click More Colors in the color indicator to access the Color Picker dialog in which you can select a color within a wider range or input a color string in the format #RRGGBB. If you want to make the background transparent, input Transparent in the text box.

Border tab

This tab shows information about borders of the crosstab. See the tab.

Color

Specifies the color of the borders.

Width

Specifies the width of the borders.

Top Line

Specifies the line style of the top border. Choose a style from the drop-down list.

Bottom Line

Specifies the line style of the bottom border. Choose a style from the drop-down list.

Left Line

Specifies the line style of the left border. Choose a style from the drop-down list.

Right Line

Specifies the line style of the right border. Choose a style from the drop-down list.

Crosstab tab

This tab shows the layout-related information of the crosstab. See the tab.

Boundary Value

Specifies the number of columns in one aggregate cell when the crosstab is displayed horizontally, or rows when displayed vertically.

Row Total on Top

Specifies whether or not to display the Total row in the first row of the crosstab.

Column Total on Left

Specifies whether or not to display the Total column in the first column in the crosstab.

Suppress Column Header

Specifies whether or not to suppress the column headers.

Suppress Row Header

Specifies whether or not to suppress the row headers.

Others tab

You can use this tab to view and configure some miscellaneous settings. See the tab.

Current Row Block Index

Specifies the vertical index of the data block that will be displayed. 0 means the first block index, and 1 the second, and so on.

Current Column Block Index

Specifies the horizontal index of the data block that will be displayed. 0 means the first block index, and 1 the second, and so on.

Items per Row Block

Specifies the number of rows of records in each data block.

Items per Column Block

Specifies the number of columns of records in each data block.

The four properties work together to control the data of the crosstab to be displayed in continuous page mode: Current Row Block Index, Current Column Block Index, Items per Row Block, and Items per Column Block.