Brio Software
Technical Publications
Home Previous Next Index Glossary
Data Analysis and Reporting with Intelligence Clients

Working with Table Columns

The following table lists some common formatting options for table columns:

Formatting Options for Table Columns 

Remove Column
To remove a selected column from the table (and Outliner), click Remove Column on the shortcut menu.
This option is available for detail and fact columns. If an item is removed from the Contents pane, it is removed from the Outliner and the data set entirely. Use caution when removing items since computed items may draw data values from the deleted item and other sections built from the Table section.
Select Column
To select a column, click anywhere inside the column.
Size Column Width
By default, Table 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 values display within the column, click the column and choose Format then Column then Auto-Size Width. If you want 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 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 Table 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 Table menu.
To unhide a column, click anywhere within the Contents pane and click Unhide Column on the shortcut menu, or choose Table then Unhide Column. When the Unhide Column dialog box appears, select the desired column and click OK.
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 then Standard Height.
Suppress Duplicates
To suppress duplicate values for a column, select the column and click Suppress Duplicates on either the shortcut menu or the Format menu.
Use this feature 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, and is available for detail and fact column selections.
Wrap Text
To wrap text within a column, select the column and click Text Wrap on either the shortcut menu or the Format menu.
Text wrap 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 the Table menu or the shortcut menu.
Sort Ascending
To sort column values in ascending order, click Sort Ascending on the Table menu, shortcut menu, or standard toolbar.
Sort Descending
To sort column values in descending order, click Sort Descending on the Table 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 Outliner line item shifts to reflect the change.



Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.