Sample Parameters (Most Recent) II

<< Click to Display Table of Contents >>

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

Sample Parameters (Most Recent) II

Report Type: Standard Report

 

Description: The Sample Parameters (Most Recent) II is a class type report created from the .dll and built based on the old Sample Parameters (Most Recent) Database Function Report. It compiles the PARAM_VALUE along with other parameters in DT_SAMPLE_PARAMETER that are obtained the most recently. It uses the Sample Parameters (Extra Fields) Report to get raw data. Note that the END_DATE input parameter is not visible by default. If the END_DATE is selected, the "most recently" will be relative to the END_DATE. The report outputs all results per sys_loc_code/param_code with null measurement_date if the most recent date is null. Otherwise, the report outputs one or more results per sys_loc_code/param_code with the measurement_date if the most recent date is not null.

 

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

 

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

 

Language: English

 

Note for Enterprise Use: This report depends on the Sample Parameters (Extra Fields) Report. For use in Enterprise, both report assemblies (EarthSoft.Reports.Library.88671.dll and .70145.dll) should be stored in the Enterprise bin folder (.\Program Files\EarthSoft\EQuIS Enterprise\bin).

 

Input Parameters: A selection you make to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location



Individual(s)


Group(s)

*Date Range



End Date

Parameter



Individual(s)


Group(s)


Unit



                                               

30010-input.param.scrnsht

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

Note: * refers to hidden parameters.

 

Tables: DT_SAMPLE_PARAMETER

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS 5.6+

 

Data Requirements: Data must be populated in DT_SAMPLE_PARAMETER

 

Report Dependencies: Depending on the Sample Parameters (Extra Fields) Report (EarthSoft.Reports.Library.88671.dll)

 

Output Type: Grid

 

Example Output: View the following example.

 

30010-output.ex_zoom70