Crystal Reports  

Customize Style Tab (Cross-Tab Expert)

Use the Customize Style tab to format your cross-tab's grid with background color, gridlines, and cell margins.

Columns
This list displays the columns you selected for your cross-tab. Select the field for which you want to customize the style.
Rows
This list displays the rows you selected for your cross-tab. Select the field for which you want to customize the style.
Summarized Fields
Use the options in this area to determine how multiple summarized fields are to be displayed.
  • Vertical

    Choose this option to display multiple summarized fields in a vertical list:

    Summary 1

    Summary 2

    Summary 3

  • Horizontal

    Choose this option to display multiple summarized fields in a horizontal list:

    Summary 1      Summary 2      Summary 3

Show Labels
Choose this option to display the names of multiple summarized fields. Labels can be displayed for both vertical and horizontal summaries.

Group Options

Suppress Subtotal
Use this check box to suppress the subtotal for a selected field. You must first have a field selected in either the Rows list or the Columns list.
Suppress Label
Use this check box to suppress the label of a suppressed subtotal field. This check box is inactive if the Suppress Subtotal check box is not selected.
Alias for Formulas
Enter an alias name for the selected row or column field. Creating an alias shortens long field names, which is useful later when you refer to a field in a conditional formatting formulas. The field's original name is shown in this box by default.
Background Color
Use this list to select a color for the selected row or column field.

Grid Options

Show Cell Margins
Select this check box to have the program automatically format the cells of the cross-tab. When this check box is not selected, any extra space (white space) within the cells of the cross-tab will be eliminated and the contents of the cells will be adjusted to utilize the least amount of space in your report as possible.
Indent Row Labels
Select this check box to indent row labels on your cross-tab. Use the inches box to specify the size of the indent you want to see.
Format Grid Lines
When you click this button, the Format Grid Lines dialog box appears. In this dialog box, you can define whether the grid lines are shown or not, as well as the color, style, and width you'd like the grid lines to have.
Repeat Row Labels
Select this check box to have the program repeat row labels on every page for cross-tabs that print across more than one page.
Keep Columns Together
Select this check box to have the program keep columns together on every page for cross-tabs that print across more than one page.
Column Totals on Top
Select this check box if you want column totals to appear at the top of the cross-tab rather than at the bottom (the default position).
Row Totals on Left
Select this check box if you want row dimensions to appear on the left of the cross-tab rather than on the right (the default position).
Suppress Empty Rows
Select this check box to have the program remove empty rows from the cross-tab. When this check box is selected, any rows whose fields do not contain any records will be hidden.
Suppress Empty Columns
Select this check box to have the program remove empty columns from the cross-tab. When this check box is selected, any columns whose fields do not contain any records will be hidden.
Suppress Row Grand Totals
Select this check box to have the program remove the grand total from rows in the cross-tab.
Suppress Column Grand Totals
Select this check box to have the program remove the grand total from columns in the cross-tab.

See Also

Cross-Tab Expert Dialog Box | Format Grid Lines Dialog Box