Location Parameters (Most Recent)

Report Name: Location Parameters (Most Recent) II

Report DLL: EarthSoft.Reports.Library.69844.dll

Dependencies:

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

Description: This class report is an updated version of the Location Parameters (Most Recent) database function report.

Installation Instructions: This report is part of the EQuIS Schema and is created when the EQuIS database is created. No additional steps necessary.

Overview: This report outputs the most recent DT_LOCATION_PARAMETER records using the Location Parameters Report. 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, with a time of 23:59:59 automatically assumed.

Tables: DT_FACILITY, DT_LOCATION, DT_LOCATION_PARAMETER, RT_GROUP, RT_GROUP_MEMBER, VW_LOCATION

Report Parameters *

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

* This report contains the following hidden parameter(s) that could affect the output of the report:

•ebatch

•facility_id

•Date Range/End

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

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

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

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML or a printer.