Formatting Results Columns

Remove Column

To remove a selected column from the table (and data layout), click Remove Column on the shortcut menu.

If you remove an item from the Contents pane, it is removed from the data layout and the data set entirely. You should approach item removal with caution since computed items may draw data values from the deleted item and the Chart, Pivot and Table sections reference the Results set.

If a computed item references the column to be deleted, a Report Refresh dialog box is displayed and prompts you to either keep the reference or to remove it.

Select Column

To select a column, click anywhere inside the column.

Size Column Width

By default Interactive Reporting truncates Results columns evenly and without regard to the length of data values. Numeric data that does not fit is replaced with pound signs (#).

To auto-size a column so that all values display, choose Format, then Column, and then Auto Size Width.For narrow or uniform columns to display values without truncation, wrap the text with each column item.

To apply the standard width to a column, click the column and choose Format, then Column, and then Standard Width.

To resize a column manually, click the column, place the cursor over the right edge of the column, and drag the right border to a new position.

Modify Column

To modify a computed column or a grouped column, select the column and choose Results, then Modify Column.

Hide/Show a Column

To hide a column, select the column and click Hide Column on either the shortcut menu or the Results menu.

To unhide a column, click anywhere within the Contents pane and click Unhide Column on either the shortcut menu or the Results menu. When the Unhide Column dialog box is displayed, select the desired column and click OK.

Hide/Show Column Titles

To hide or show column titles, choose Format, then Column Titles.

When column titles are hidden, the Column Titles option is unchecked

When column titles are displayed, the Column Titles option is checked.

Size Titles

To apply a custom height to a title, drag the bottom edge of a title row to the new position.

To apply the standard height to a title row, choose Format, then Row, and then Standard Height.

Suppress Duplicates

To suppress the duplicate values for a column, select the column and click Suppress Duplicates on either the shortcut menu or the Format menu.

Use this option to display 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.

Note: This option is available for detail and fact columns.

Wrap Text

To wrap text within a column, select the column and click Text Wrap on either the shortcut menu or the Format menu.

Note: This option is available for detail and fact columns.

Group Columns

To merge dimension labels into new groupings and aggregate the associated data, click Add Grouping Columns on either the shortcut menu or the Results menu.

Sort Ascending

To sort column values in ascending order, click Sort Ascending on the Results menu, shortcut menu, or standard toolbar.

Sort Descending

To sort column values in descending order, click Sort Descending on the Results menu, shortcut menu, or standard toolbar.

Move Column

To move a column, click the column in the Contents pane and drag it to a new position. The corresponding data layout item shifts to reflect the change.