Table Column Formatting Options

Changing the Column Name Heading (Title)

To modify the column title, click Expression on the Section title bar, then select the column title that you want to modify. In the Expression line, type the new title between the quotation marks (“ ”) and click the check mark.

Hide/Show Column Name Heading (Title)

To toggle the display of column titles, select Column Titles on the shortcut menu. A check mark is displayed next to Column Titles to indicate that column titles are visible. Select this option again to clear the check mark and hide column titles from view.

Remove Column

To remove a selected column from the report (and Table data layout), select Remove Column on the shortcut menu. This option is available for dimension and fact columns. Items should be removed with caution as computed items may draw data values from the deleted item.

Hide/Show Column Total

To toggle the display of column totals, select Show Column Totals on the shortcut menu. A check mark is displayed next to Column Totals to indicate that column totals are visible. Select this option again to clear the check mark and hide column totals from view.

This option is available only for fact columns.

Select Column

Click anywhere inside the column.

Suppress Duplicates

To suppress the duplicate values for a column, select the column and select Format, then Suppress Duplicates. Use this feature if you want to display only the first instance in the column of a duplicate value when individual database records include redundant information. This feature is especially useful if records are associated with the same date, location or customer.

Text Wrap

To wrap text within a column, select the column and select Format, then Text Wrap.

Sort Ascending/Descending

To sort column values, click Sort Ascending or Sort Descending on the Table menu, shortcut menu, or standard toolbar.

Reordering Columns

If you want the columns in the table to be displayed in a different order, drag the item in order of how you want it to be displayed in the Table data layout. You can also select the column in the actual report and drag it to a new position in the report.