<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Action Level Reports >


Report Name: ARII-ALEII Crosstab


Report Type: Standard


Description: The ARII-ALEII Crosstab Report 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.


This report newly provides stream-lined crosstab output and is therefore limited, for now, 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 ARII-ALEII 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 DT_ACTION_LEVEL and DT_ACTION_LEVEL_PARAMETER.


For more information refer to the following EarthSoft Online Help articles: Analytical Results II (50943), and  Action Level Exceedance II with Parameters (51297) as well as Crosstab Reports.  


Report Dependencies: Analytical Results II (50943) and Action Level Exceedance II with Parameters (51297)  


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


Contact for a direct file link.


Language: English


Input Parameters: A selection made to customize the output of a report. Note that the Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.


Input Parameters

Input Parameter Screenshot

Output Columns

Analytical Results





Additional Fields

Crosstab Configuration

Column Headers

Row Headers

Tabbed Data

Display Action Level

Action Level

Action Level 1

Format 1

Action Level 2

Format 2

Action Level 3

Format 3

Action Level 4

Format 4

Action Level 5

Format 5

Action Level 6

Format 6



Matching - Default

Matching - Special



Matching - Default

Matching - Special

Matching - Default

Matching - Special



Contact for more information.


*Note: The screenshot in the table above shows partially expanded parameters. Refer to related report articles for complete input parameter lists (e.g. Analytical Results II and Action Level Exceedance II with Parameters).


Tables: The report uses the same tables as the ALE II Report


Database Type: SQL


Database Schema: Standard (no custom or add-on schemas required)


Database Version: EQuIS 7


Data Requirements: N/A


Report Requirements: N/A


Output Type: Excel


Example Output: View the following example or download the following attachment, ARII-ALEII Crosstab Results_Springfield_20190208.xlsx.


Example Output in Excel:


Example Output in Excel