<< 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 |
||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021