Using the Column Heading Menu

Use the Column Heading menu to sort in ascending or descending order, hide a column, create a Control Break, or to create a search filter.

Clicking a column heading in an interactive report displays the Column Heading menu. Positioning the cursor over each icon displays a tooltip that describes its function.

Description of the illustration ir_col_head_menu.png

Column Heading menu options include:

• Sort Ascending - Sorts the report by the column in ascending order.

• Sort Descending - Sorts the report by the column in descending order.

• Hide Column - Hides the column. Not all columns can be hidden. If a column cannot be hidden, the Hide Column icon does not display. To show a hidden column, select Reset from the Actions menu.

• Control Break - Creates a break group on the column. This pulls the column out of the report as a master record. See Creating a Control Break.

• Column Information - Displays help text about the column, if available.

• Filter - Enter a case insensitive search criteria. Entering a value reduces the list of values at the bottom of the menu. You can then select a value from the bottom. The selected value will be created as a filter using either the equal sign (=) or contains depending on the List of Values Column Filter Type.