Sample Parameters (Extra Fields)

Report Name: Sample Parameters (Extra Fields) (example)

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

Report Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: The Sample Parameters (Extra Fields) is a class type report created from the .dll and built based on the old Sample Parameters

Database Report. This report adds the functionality of reporting more selective fields. It fills non-numeric PARAM_VALUE in the PARAM_TEXT column of the report, and nothing in the PARAM_VALUE column. It fills numeric PARAM_VALUE in both PARAM_VALUE and PARAM_TEXT columns.

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

Overview:

Tables: DT_FACILITY, DT_SAMPLE, DT_SAMPLE_PARAMETER, VW_LOCATION

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Measurement
Date Range	Section to select the start date and end date measurement date range.
Task(s)	Selct one or more sample parameter task codes.
Parameter
Individual(s)	Select one or more sample parameters.
Group(s)	Select one or more sample parameter groups.
Unit	Single-select for a UNIT to which all results will be converted. See sections on Unit Conversions and Skip Missing Unit Conversions below.
Additional Fields

* The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.

** This report contains the hidden parameter: ebatch

Report Output
FACILITY_ID FACILITY_CODE SYS_LOC_CODE LOC_NAME LOC_GROUP LOC_REPORT_ORDER MEASUREMENT_DATE	PARAM_CODE PARAM_VALUE PARAM_TEXT PARAM_UNIT MEASUREMENT_METHOD TASK_CODE	X_COORD Y_COORD LONGITUDE LATITUDE SYS_SAMPLE_CODE SAMPLE_NAME EXTRA FIELDS if selected

Report Output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER

MEASUREMENT_DATE

PARAM_CODE

PARAM_VALUE

PARAM_TEXT

PARAM_UNIT

MEASUREMENT_METHOD

TASK_CODE

X_COORD

Y_COORD

LONGITUDE

LATITUDE

SYS_SAMPLE_CODE

SAMPLE_NAME

EXTRA FIELDS if selected

Note: The Location Name ("LOC_NAME" field) for this report is pulled from VW_LOCATION. Any location that does not have a correctly configured record in DT_COORDINATE (where DT_COORDINATE.COORD_TYPE_CODE = DT_FACILITY.COORD_TYPE_CODE and DT_COORDINATE.IDENTIFIER = DT_FACILITY.IDENTIFIER) will not be displayed. As a workaround, select the DT_LOCATION.LOC_NAME field as an "Additional Fields" parameter to display the Location Name from the DT_LOCATION table. This will be resolved in a future release of EQuIS Professional.

Unit Conversion

Unit Conversion is handled by the unit conversion function within the database, which relies on the conversion factors stored in the RT_UNIT_CONVERSION_FACTOR table. If the report fails to convert units, it generates an informative "MISSING UNIT CONVERSION FACTOR - cannot convert ..." error message. Note only the first encountered missing unit conversion factor will be included in the error message; additional errors may occur after the initial error is resolved.

Skip Missing Unit Conversions

A hidden parameter, Skip Missing Unit Conversions is available for configuring the report to skip failed result unit conversions and generate a row of param_value=original numeric param_value or null if non-numeric, param_text=original param_value and param_unit = original param_unit. The Skip Missing Unit Conversions parameter defaults to unchecked (default_value=false) and can be set in the database (ST_REPORT_PARAMETER) and made visible, if necessary. The report must first be published to the database for the report parameters to display in ST_REPORT_PARAMETER.

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML or a printer.