Save Crosstab Parameters

The EQuIS Professional Crosstab Creator allows you to create and define a specific format for viewing crosstabbed data.

Save Crosstab Selections

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.

Use Saved Crosstab Selections

After running a report and opening the Crosstab Form, click Open and select the saved .xml file.

Note: In Build 7.20.2, the field name output from the Additional Fields parameter will no longer be limited to 30 characters in length and will be tableName_fieldName, e.g. DT_DRILL_ACTIVITY_CUSTOM_FIELD_1 instead of DRILL_ACTIVITY_CUSTOM_FIELD_1 or DT_WATER_LEVEL_MEASURED_DEPTH_OF_WELL instead of WATERLEVELMEASUREDDEPTHOFWELL etc. Therefore, any saved crosstab *.xml configuration file that used one of the Additional Fields (listed below) in a row or column header, must be recreated and resaved. In addition, any published crosstabs that used one of the Additional Fields (listed below) as a row or column header must be republished.

WATERLEVELMEASUREDDEPTHOFWELL

WATER_LEVEL_MEASUREMENT_METHOD

WATER_LEVEL_MEASUREMENT_DATE

WATER_LEVEL_WATER_LEVEL_ELEV

WATER_LEVEL_DIP_OR_ELEVATION

WATERLEVELCORRECTEDELEVATION

WATER_LEVEL_DRY_INDICATOR_YN

WATER_LEVEL_WATER_LEVEL_DEPTH

WTRLVLHSTRCLRFRNCLV

DRILL_ACTIVITY_CUSTOM_FIELD_1

DRILL_ACTIVITY_CUSTOM_FIELD_2

DRILL_ACTIVITY_CUSTOM_FIELD_3

DRILL_ACTIVITY_CUSTOM_FIELD_4

DRILL_ACTIVITY_CUSTOM_FIELD_5

WELL_HISTORICAL_REFERENCE_ELEV

Differing Action Levels between Saved Crosstab File and Current Report

When loading a saved Crosstab and finding that a saved action level parameter does not exist in the crosstab configuration of the current grid data or crosstab report, the Crosstab tool replaces it with an existing one of the current crosstab configuration.

Examples:

1.In the saved XML file, Row Header(s) has x_action_level and 1_FLAG and the former exists but the latter does not exist in the available selections of Column of the current crosstab configuration. The Crosstab tool replaces 1_FLAG with x_FLAG.

2.Row Header(s) has 1_action_level and 1_FLAG, and neither exist in the available selections. The Crosstab tool replaces them with x_action_level with x_FLAG, where 'x' is an action level code that exists in the available selections.

Notes:

1.The above example indicates users can turn a saved crosstab configuration into one that can be used by different grid data or a crosstab report by modifying specific x_action_level etc. to 1_action_level etc., where x is ACTION_LEVEL_CODE.

2.In updating the saved .xml file, if Row Header(s) has <Column>1_action_level</Column> and <Caption>1</Caption>, they will be updated to Column = x_action_level and Caption = x.

Mismatches between Saved Crosstab and Current Report

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.

For further advice on mismatch errors in published crosstabs using action levels, see Troubleshooting Published Crosstabs.

Overwrite Action Level Captions

If you manually edit a Caption on an Action Level in the Column Headers or Row Headers section and save the crosstab configuration, it is possible to have Crosstab automatically overwrite Action Level captions in the Column Headers or Row Headers with the name(s) of the Action Levels selected in the base report.

To have this function available in Crosstab, an administrator can 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