<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports > 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.
It is possible to run this report in a facility group by altering the DEFAULT_VALUE for the @facilityids parameter by doing the following:
1.Publish the Facility Parameters Report with a new name, following Handling Multiple Copies of 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 |
||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.
Copyright © 2023 EarthSoft, Inc • Modified: 25 Nov 2021