The Column Chooser button is in the toolbar above tables and grid output in EQuIS Professional, above each data section in EDP, and is also available by right-clicking inside grids.
The Column Chooser button in both Professional and EDP displays a drop-down menu that allows you to do the following:
•Open Dialog for changing the visibility of each individual column
•Load custom column configurations
•Save custom column configurations
•Show Required Only (only required columns)
•Hide All columns
•Hide Blanks (columns containing no data)
•Autofit columns (Quick and All options)
The Column Chooser button in both Professional and EDP displays a drop-down list containing a button for each of the Column Chooser functions.
Click Open Dialog to open the Column Chooser interface, which shows a list of columns for which visibility can be changed manually, as in the DT_FACILITY example below.
Note: The Caption and Key fields are displayed to minimize confusion if custom captions have been applied to data fields.
Click AutoFit Column Width (Quick) to automatically resize each column to fit date in the first 300 rows. This setting is persistent between tables and sessions of EQuIS Professional. This option cannot be used with the AutoFit Column Width (All) option.
Click AutoFit Column Width (All) to automatically resize each column to fit all the data in a table. This setting is persistent between tables and sessions of EQuIS Professional. The calculations to resize each column will happen in the background and the status will appear on the status menu in Professional. The process can be canceled by unchecking the option. This option cannot be used with the AutoFit Column Width (Quick) option.
From the Column Configuration dropdown in the grid output, click "Publish Column Configuration" to publish the configured columns to a user report. Column Configurations can be saved to an existing user report or a new user report can be created for the same base report.
If the report was run with an existing user report, the user report name will be automatically populated:
If a new user report name has been entered, a prompt will appear to create a new user report:
User reports with published Column Configurations:
•will automatically apply the configuration when the report runs
•will appear in the user report drop-down list with (cc) in the name
•can be used in the EZView Widget in Enterprise
•The column configuration is not respected for EQuIS grid reports requested via the REST API for output types PDF or JSON.
•When using a report with a saved column configuration in ArcEQuIS, the attribute table can only be viewed if the report is added to the map as a Snapshot.
Copyright © 2022 EarthSoft, Inc • Modified: 08 Aug 2021