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
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.
Tables: DT_FACILITY, DT_SAMPLE, DT_SAMPLE_PARAMETER, VW_LOCATION
* 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
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 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.
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021