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 EarthSoft.Reports.Library.88671.dll and built based on the original Sample Parameters database report.

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

Overview: This report can add more fields via the Extra Fields parameter. 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.

Non-Numeric Sample Parameters

An administrator can modify the published report to include non-numeric sample parameters by removing the "isnumeric" clause from the @param_codes report parameter's DATA_SOURCE, as shown below:

select distinct sp.param_code, coalesce(spt.param_desc,sp.param_code) as Description from dt_sample_parameter sp inner join rt_sample_param_type spt on sp.param_code = spt.param_code where isnumeric(sp.param_value) = 1 and facility_id in (select facility_id from dbo.fn_facility_group_members(@facility_id)) order by [Description]

For instructions on modifying the DATA_SOURCE for a report parameter, see the Parameter Selection List (DATA_SOURCE) article.

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

* This report includes the following hidden parameter(s) that could affect the output of the report:

•ebatch

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

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.