ArcEQuIS Crosstab

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports >

ArcEQuIS Crosstab

Report Name: ArcEQuIS Crosstab

File Name: EarthSoft.Reports.Library.160273.dll

Dependencies:  Analytical Results II (EarthSoft.Reports.Library.50943.dll) and Action Level Exceedance II with Parameters (EarthSoft.Reports.Library.51729.dll)

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Description: The ArcEQuIS Crosstab report is based on the ARII-ALEII Crosstab Report and generates, in a single step, cross-tabbed analytic results by themselves or with the results compared to up to six action levels with action level exceedances indicated with selected formatting. It uses the Analytical Results II and Action Level Exceedance II reports and an internal call to the Crosstab functionality to generate output and examine action level exceedances, including support for advanced action levels.

 

Installation Instructions: This report assembly is part of the EQuIS Professional installation. The report must be published to the database to be used in the Reports modal as an ad hoc report crosstab in ArcEQuIS.

 

Overview:

This report newly provides streamlined crosstab output and is limited to basic crosstab formatting options. For example, multiple action level formats can be selected, with a font format and background shade per action level, but font color is currently not available. If multiple background shades are selected for a single action level, the first color in the list will be displayed. To access more complex formats, use the Crosstab Form for manual selections.

 

Similarly, the ArcEQuIS Crosstab Report includes most of the input parameters from the ALE II with Parameters Report, in addition to the new Crosstab Configuration inputs shown below. The following ALEII parameters are not used: Action Level\Flagging\Exceedance Flag and Warning Flag and Include\Custom Fields from the DT_ACTION_LEVEL and DT_ACTION_LEVEL_PARAMETER tables.

 

Notes:

•By default, this report uses ST_REPORT_PARAMETER.DISPLAY_TYPE = "MultiSelectNonAlpha" to allow the report parameter selections for the Crosstab Column Headers, Row Headers and Tabbed Data to stay in the order that they were selected. (Typically, ST_REPORT.DISPLAY_TYPE = "MultiSelect" so that parameter selections are automatically arranged in alphabetical order.)

•Add X_COORD and Y_COORD fields in the configuration section or the report will not run in ArcEQuIS.

 

Report Parameters

Analytical Results section

Location

Location section for selecting individual locations, location groups and whether the DT_GEOGRAPHY table should be used for coordinates.

Sample

Section for selecting sample related parameters.

Test

Section for selecting test related parameters.

Result

Section for selecting result related parameters.

Additional Fields

Section for selecting additional fields if they've been configured.

Crosstab Configuration section

Add X_COORD and Y_COORD fields in the configuration section or the report will not run in ArcEQuIS.

Column Headers

Choose which fields to include in column headers.

Row Headers

Choose which fields to include in row headers.

Tabbed Data

Choose which fields to include in the tabbed data.

Display Action Level

Choose to display action level in the column header or row header.

Action Level section

Action Level 1

Select one action level to use for comparison.

Format 1

Select one format

Action Level 2

Select one action level to use for comparison.

Format 2

Select one format

Action Level 3

Select one action level to use for comparison.

Format 3

Select one format

Action Level 4

Select one action level to use for comparison.

Format 4

Select one format

Action Level 5

Select one action level to use for comparison.

Format 5

Select one format

Action Level 6

Select one action level to use for comparison.

Format 6

Select one format

Comparison

Operator

Select an operator: <, <=, >, >=

Unit

Select a comparison unit: ACTION_LEVEL_UNIT or REPORT_RESULT_UNIT.

Significant Figures

Select the desired number of significant figures.

Compare to Action Level Before Applying to Significant Figures

Select 'Yes' to compare results before significant figures are applied. Select 'No' to compare results After significant figures are applied.

Display in scientific notation

Yes | No

Flagging

Show Results

Select 'Show All' to show all results (with exceedances flagged) OR 'Show Only Exceedances' OR 'Show With Any Exceedance' to show results that exceed any of the selected action levels.

Flag Non-Detects

Select 'Yes' to flag non-detect results whose detection limit exceeds the action level OR 'No' to not flag them.

Matching Default

Match Facility

Match Matrix

Match Fractions

Match Method

Match Depth

Depth Type

Section for default matching conditions. Default values for this section are True. The default depth type is Sample Depth.

Matching Special

Match Subfacility

Match Start-End Dates

Match Seasonal Dates

Match Land Use

Match Geologic Unit

Geologic Unit Code or Type

Geologic Unit Columns

Section for special matching conditions. Default values for this section are False. The Geologic Unit section also includes parameters for Geologic Unit Code or Type and Geologic Unit Columns and does not have defaults.

* This table shows partially expanded parameters. Refer to related report articles for complete input parameter lists (e.g., Analytical Results II.)

 

** The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.

 

Note: If the same action level is used in more than one action level parameter (e.g., the same ACTION_LEVEL_CODE for the Action Level 1 parameter selection and the Action Level 2 parameter selection), the report will not generate output.

 

Comparison | Operator Parameter: There are four options for the Comparison | Operator parameter:

•"<"   Within Limits (Exclusive): The analytical result is flagged as an exceedance if it is less than the action level and, if one exists, greater than the action_level_min. Equalities are not considered exceedances.

•"<=" Within Limits (Inclusive): Same as above, but equalities are considered exceedances.

•    ">"   Exceeds Limits (Exclusive): The analytical result is flagged as an exceedance if it is greater than the action level, or, if one exists, less than the ACTION_LEVEL_MIN. Equalities are not considered exceedances.

•">=" Exceeds Limits (Inclusive) (the default): Same as above, but equalities are considered exceedances.

 

Comparison | Unit Parameter: There are two options for the Comparison | Unit parameter:

•"report_result_unit": Values will be displayed in the units of the REPORT_RESULT column. Other columns will be converted to matching units as necessary.

•"action_level_unit": Values will be displayed in the units of the ACTION_LEVEL column. Other columns will be converted to matching units as necessary.

 

 

Report Output

The output is a crosstab dependent upon the crosstab configuration section. By default, the crosstab, with no selections in the crosstab configuration section will include the following configuration:

Column Headers: Sample Date, Loc Code, Sample Code:

Row Headers: CAS RN, Chemical Name, Report Result Unit, Action Level(s)

 

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML or a printer.

 

 



Copyright © 2024 EarthSoft, Inc. • Modified: 09 Dec 2024