Gauging and Analytical Report

<< Click to Display Table of Contents >>

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

Gauging and Analytical Report

Report Name: Gauging and Analytical Report (example)

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

Dependencies: v54.analytical_results and v54.water_level

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

 

Description: This report creates a Crosstab Report in Excel. The columns include water level (i.e., gauging data) information, followed by the selected analytes.

 

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

 

Overview:

Note this report calls upon the standard Water Levels database function report. Any customized water_level reports that are newer than the standard EarthSoft v54.water_level report 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).

 

Source Tables DT_WELL, RT_GROUP, RT_MTH_ANL_GROUP

 

Report Parameters

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Sample


Type(s)

Select one or more sample types.

Date Range

Section to select the start date, end date, most recent sampling, and the option to use date range to select the most recent sampling events.

Matrix(es)

Select one or more sample matrix.

Task(s)

Select one or more tasks.

Delivery Group(s)

Select one or more delivery group.

Depth

Section for selecting the minimum and maximum start and end depths as well as depth unit.

Test


Method(s)

Select one or more test method.

Fraction(s)

Select one or more fraction.

Column Number(s)

Select one or more column number.

Type(s)

Select one or more test type.

Lab Matrix(es)

Select one or more lab matrixes.

Prep Method(s)

Select one or more prep methods.

Result


Analyte

Section for selecting individual analytes and analyte groups.

Unit

Selection for report result units.

Type(s)

Select one or more result type.

Detect Flags

Select one or more options for detect flag.

Non-Detect Multiplier

Enter the desired non-detect multiplier value.

Non-Detect Symbol

Enter the desired non-detect symbol ("< ?", "ND", ...).  "?" will be replaced with reporting limit multiplied by non-detect multiplier.

Reportable

Select one or more options for reportable result.

Reporting Limit

Select which reporting limit you desire to use (reporting_detection_limit, method_deteciton_limit, etc.)

 

 

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.