Right-click a column heading to display a list of options.
Browse Column Options
With the column options, you can:
• Use Autosize Columns to resize browse columns based on the size of the displayed data. By default, the browse displays with columns already autosized. If you turn this option off and manually adjust column sizes, your settings for each browse are retained between sessions. If a cell’s data exceeds the column width, three dots (...) are displayed on the right.
Note: When you are viewing all records in a browse (Records to show set to All) and Autosize Columns is on, the autosized column widths are based on the first 500 records for performance reasons.
• Use the Group By functions to create and manage custom views of the browse data. Group By functions are available only when all records are being viewed.
• Use Summary to get a summary of the data in the browse column. If the data in the column is numerical, you can get a summary based on the following:
Count. Displays the number of items in an x-axis group. (This is the only summary option available for non-numerical data.)
Sum. Displays the sum of the values in the column.
Average. Displays the average of the values in the column.
Minimum. Displays the minimum of the values in the column.
Maximum. Displays the maximum of the values in the column.
The summaries are displayed below the column in a Summaries area.
• Use Hide Column to remove a column from display.
• Use Reset to Factory Settings to return to the default column display settings. The search conditions, autosizing, page sizing, and chart definition are all reset.
• Use Columns to display a list of all columns defined for the browse and toggle the show/hide settings. You can use this to restore a column that was previously hidden. This option displays the Column Maintenance screen, in which you select the columns to be displayed and the position in which they appear on the screen. The position numbers range from left to right on the screen, and you assign new numbers to columns according to where you want them to appear.
• Use Properties to display technical information about the data in the column. This includes the name of the current program and the database table and field where the data for the column is stored.