Gauging and Analytical Report

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results >

Gauging and Analytical Report

Report Name: Gauging and Analytical Report (16062)

 

Report Type: Standard

 

Description: This report creates a Crosstab Report in Excel. The columns include water level (i.e., gauging data) information, followed by the selected analytes. Note this report calls upon the standard Water Levels Report dll. Any customized water_level reports which are newer than the standard EarthSoft v54.water_level may produce an error generating output.

 

This report has a special ordering logic; it does not use RT_MTH_ANL_GROUP_MEMBER.DISPLAY_ORDER. The report output is first sorted by Well ID (DT_WATER_LEVEL.SYS_LOC_CODE/DT_SAMPLE.SYS_LOC_CODE), and then by gauging date (DT_WATER_LEVEL.MEASUREMENT_DATE/DT_SAMPLE.SAMPLE_DATE). Columns not included in this logic are ordered alphabetically or numerically (for string or numeric values, respectively).

 

Report Dependencies: There are no dependencies for this report.

 

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

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual(s)



Group(s)


Sample




Type(s)



Date Range




Start



End

Matrix(es)



Task(s)



Delivery Group(s)



Depth




Minimum Start Depth



Maximum End Depth



Unit


Test




Method(s)



Fraction(s)



Column Numbers(s)



Type(s)



Lab Matrix(es)



Prep Method(s)


Result




Analyte




Individual(s)



Group(s)

Unit



Type(s)



Detect Flag(s)



Non-detect Multiplier



Non-detect Symbol



Reportable



Reporting Limit



30041-input.params.scrnsht.c

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

 

Tables: DT_WELL, RT_GROUP, RT_MTH_ANL_GROUP

 

Database Type: SQL

 

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

 

Database Version: EQuIS 5+

 

Data Requirements: None

 

Report Requirements: Excel

 

Output Type: Excel

 

Example Output: Download the example here or view the example below.

 

30041-ex.output_zoom97

 

EarthSoft.Reports.Library._16062.GaugingAndAnalyticalReport