Multi-Group - Analytical Report

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results >

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

 

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