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