<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports > Sample Parameter Reports > 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 |
||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||
* 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 |
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.
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021