Save Crosstab Parameters
Copyright © 2020 EarthSoft, Inc • Modified: 24 Feb 2020
The EQuIS Professional Crosstab Creator allows you to create and define a specific format for viewing crosstabbed data.
Defined parameters and settings can be saved and shared with other EQuIS users as an *.xml configuration file. Saving the configuration will not save the crosstab data, but will save the parameters and settings of the crosstab design.
Click Save to save the configuration.
The default folder when saving a crosstab configuration for the first time is the My EQuIS Work\DatabaseName\FacilityName folder. The latest folder used will be remembered the next time a crosstab configuration is saved or opened.
When a saved Crosstab is run, it checks to see if there is a mismatch of columns between the base report (such as the Action Level Exceedance Report) and the Column and Row Header columns in a saved or published Crosstab configuration. This includes a check to make sure the base report does not have more Action Levels selected than are in the Crosstab configuration. They do not have to be the same Action Levels, just the same or a fewer number of Action Levels.
If a conflict is found when opening a saved Crosstab in the Crosstab GUI, a message advises the user to review the configuration columns before running the Crosstab.
If the Crosstab function is called by a published Crosstab report, and a mismatch check is triggered, an exception is thrown without running the report and a very detailed exception message is presented.
It is possible to have Crosstab automatically over-write Action Level captions in the Column Headers or Row Headers with the name(s) of the Action Levels selected in the base report (if different from the original Action Levels used to create a saved Crosstab configuration).
To have this function available in Crosstab, add a row to ST_CONFIG with the following:
•CONFIG_SECTION = crosstab
•CONFIG_KEY = ignore_action_level_caption
•STRING_VALUE = yes
•ALL OTHER FIELDS NULL