Facility Parameters

Report Name: Facility Parameters (example)

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

Report Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: The Facility Parameters Report generates the facility parameter information from DT_FACILITY_PARAMETER and other selectable fields from DT_FACILITY, DT_FACILITY_PARAMETER and RT_FACILITY_PARAM_TYPE.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview:

In the output, REPORT_RESULT_UNIT equals "Parameter\Unit:", RT_FACILITY_PARAM_TYPE.STANDARD_UNIT or DT_FACILITY_PARAMETER.PARAM_UNIT by order. For example, if "Parameter\Unit:" is not selected and RT_FACILITY_PARAM_TYPE.STANDARD_UNIT is not populated, REPORT_RESULT_UNIT equals DT_FACILITY_PARAMETER.PARAM_UNIT. REPORT_RESULT_VALUE equals DT_FACILITY_PARAMETER.PARAM_VALUE converted in the order of "Parameter\Unit:", RT_FACILITY_PARAM_TYPE.STANDARD_UNIT or DT_FACILITY_PARAMETER.PARAM_UNIT.

The report requires RT_GROUP_MEMBER.MEMBER_CODE = RT_FACILITY_PARAM_TYPE.PARAM_CODE. It fails if the required data are not populated and Parameter - Individual(s)/Group(s) are selected.

Users can run this report in a facility group by altering the DEFAULT_VALUE for the @facilityids parameter:

1.Publish the Facility Parameters Report with a new name, following Handling Multiple Copies of the Same Report.

2.Open ST_REPORT, find this new report, and make note of its REPORT_ID.

3.Open ST_REPORT_PARAMETER and filter on the REPORT_ID from Step 2.

4.For the record where PARAM_NAME =@facilityids, delete the following from DEFAULT_VALUE:

$select facility_id from dt_facility where facility_id=@facility_id

Tables: DT_FACILITY, DT_FACILITY_PARAMETER, RT_GROUP, RT_GROUP_MEMBER, RT_FACILITY_PARAM_TYPE, RT_UNIT

Report Parameters

Facility(s)	Input parameter for facility selection.
Measurement
Date Range	Input parameter for selecting the start and end date.
Task(s)
Parameter
Individual(s)	Selection for individual parameters.
Group(s)	Selection for parameters groups.
Unit	Selection for parameter unit.
Additional Fields

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