Sample Parameters (Extra Fields)
Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
Report Name: Sample Parameters (Extra Fields)
Report Type: Standard Report
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.
Note: This report attempts unit conversion to display results in like units. When the PARAM_UNIT is not set, the corresponding report output is set to a flag value indicating a conversion error. These flag values are 1E+8 or 99999999.
Contact email@example.com for more information.
File Name: EarthSoft.Reports.Library.88671.dll
Contact firstname.lastname@example.org for a direct file link.
Input Parameters: A selection you make to customize the output of a report.
Please note that the Additional Fields parameter may be customized as explained here.
LOC_GROUP, LOC_REPORT_ORDER, MEASUREMENT_DATE, PARAM_CODE, PARAM_VALUE,
PARAM_UNIT, MEASUREMENT_METHOD, TASK_CODE,
LATITUDE, SYS_SAMPLE_CODE, SAMPLE_NAME
EXTRA FIELDS if selected
Note: * refers to hidden parameters
Database Type: SQL
Database Schema: Standard (no custom or add-on schemas required)
Databse Version: EQuIS 5.6+
Data Requirements: N/A
Report Requirements: N/A
Output Type: Grid
Example Output: View the following example.
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, you can 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.