Multi-Group - Analytical Report

Report Name: Multi-Group - Analytical Report (example)

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

Dependencies: Saved Analytical Results user report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

Description: This report generates a predefined crosstab report based on a saved Analytical Results report.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview:

The contents of this crosstab report include the following details:

•ColumnHeaders: CHEMICAL_NAME, REPORT_RESULT_UNIT

•RowHeaders: SYS_LOC_CODE, START_DEPTH, END_DEPTH, SAMPLE_DATE, LOC_GROUP

•TabbedData: REPORT_RESULT_TEXT, Qualifier

It also adds the following notes to the bottom of the Crosstab:

Qual = Data Qualifiers: J=estimated, U=below detection limit, UJ estimated as non-detect

mg/L = micrograms per liter

PCE = tetrachloroethylene

TCE = trichloroethylene

bgs = below ground surface

Source Tables DT_FIELD_SAMPLE, DT_STATIC_PROPS, DT_TEST, DT_RESULT, RT_ANALYTE, RT_MTH_ANL_GROUP, RT_ANALYTE_VAR, VW_LOCATION, DT_TASK, RT_MTH_ANL_GROUP_MEMBER

Report Parameters

Saved Analytical Results Report	Select a saved Analytical Results user report.
Qualifier	Select a qualifier: interpreted qualifier, lab_qualifier or validator_qualifier

Report Output
SYS_LOC_CODE SYS_SAMPLE_CODE SAMPLE_DATE SAMPLE_DATE_CODE START_DEPTH END_DEPTH MATRIX_CODE TASK_CODE TASK_DESC FIELD_SDG LAB_MATRIX_CODE ANALYTIC_METHOD COLUMN_NUMBER	FRACTION LEACHATE_METHOD LEACHATE_DATE LAB_SDG METHOD_ANALYTE_GROUP REPORT_ORDER CAS_RN CHEMICAL_NAME ORGANIC_YN REPORT_RESULT_TEXT REPORT_RESULT_VALUE REPORT_RESULT_UNIT REPORTABLE_RESULT	DETECT_FLAG INTERPRETED QUALIFIERS REPORTING_DETECTION_LIMIT DETECTION_LIMIT_UNIT APPROVAL_CODE RESULT_TEXT RESULT_NUMERIC RESULT_UNIT X_COORD Y_COORD Z_COORD_AVG ZFROM ZTO

Report Output

SYS_LOC_CODE

SYS_SAMPLE_CODE

SAMPLE_DATE

SAMPLE_DATE_CODE

START_DEPTH

END_DEPTH

MATRIX_CODE

TASK_CODE

TASK_DESC

FIELD_SDG

LAB_MATRIX_CODE

ANALYTIC_METHOD

COLUMN_NUMBER

FRACTION

LEACHATE_METHOD

LEACHATE_DATE

LAB_SDG

METHOD_ANALYTE_GROUP

REPORT_ORDER

CAS_RN

CHEMICAL_NAME

ORGANIC_YN

REPORT_RESULT_TEXT

REPORT_RESULT_VALUE

REPORT_RESULT_UNIT

REPORTABLE_RESULT

DETECT_FLAG

INTERPRETED QUALIFIERS REPORTING_DETECTION_LIMIT DETECTION_LIMIT_UNIT

APPROVAL_CODE

RESULT_TEXT

RESULT_NUMERIC

RESULT_UNIT

X_COORD

Y_COORD

Z_COORD_AVG

ZFROM

ZTO

1Excel report output requires a valid license of Microsoft Excel to view the output.