Sample Parameters (Most Recent) II

Report Name: Sample Parameters (Most Recent) II (example)

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

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

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

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.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary. For Enterprise use, copy EarthSoft.Reports.Library.70145.dll and EarthSoft.Reports.Library.88671.dll from the EQuIS Professional installation directory into the Enterprise bin directory.

Overview:

This report uses the Sample Parameters (Extra Fields) Report to get raw data. Data must be populated in DT_SAMPLE_PARAMETER in order for this report to function. 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.

Tables: DT_SAMPLE_PARAMETER

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Parameter
Individual(s)	Select one or more sample parameters.
Group(s)	Select one or more sample parameter groups.
Unit	Select the desired reporting unit.

* This report contains the hidden parameter: Date Range

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

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

1Excel report output requires a valid license of Microsoft Excel to view the output.