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 the help document about this feature.
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.
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.
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.
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.
