Sample Parameters (Extra Fields)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Sample Parameter Reports >

Sample Parameters (Extra Fields)

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 support@earthsoft.com for more information.

 

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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

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.

 

Input Parameters

Output Columns

Location




Individual(s)



Group(s)


Measurement

Date Range




Start Date



End Date

Measurement




Task(s)


Parameter




Individual(s)



Group(s)



Unit


Additional Fields



                                               

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: * refers to hidden parameters

 

Tables: DT_SAMPLE_PARAMETER

 

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.

 

30086-ex.output_zoom55

 

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.