ARII-ALEII Crosstab

<< Click to Display Table of Contents >>

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

ARII-ALEII Crosstab

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 support@earthsoft.com 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



Location


Sample


Test


Result


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


Comparison


Flagging


Matching - Default


Matching - Special


Comparison


Flagging


Matching - Default


Matching - Special


Matching - Default


Matching - Special

 

arii_aleii_crstb_input_params

Contact support@earthsoft.com 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