Basic Results II
Copyright © 2020 EarthSoft, Inc • Modified: 24 Feb 2020
Report Name: Basic Results II
previously called (Beta) Basic Results
Report Type: Standard Report
Description: In addition to reporting the content of DT_BASIC_RESULT, the Basic Results II Report also provides measured results with unit conversion, if users provide a unit over the user interface. The converted results are in REPORT_RESULT_TEXT, REPORT_RESULT_VALUE and REPORT_RESULT_UNIT. Chemical names, geological coordinates and elevations are also listed. It is a class version of the old stored procedure report, Basic Results, but improved in terms of working with multiple facilities. Column FACILITY_CODE is added onto lists of Location/Individuals or Groups and Analyte/Groups of the user interface.
Note 1: Working with Multiple Facilities
1. Individual and group location selection and analyte group selection can work with multiple facilities. When logged in to Professional as a facility group, the locations and analyte groups of all the facilities in the facility group will be displayed on the user interface. RT_GROUP_MEMBER.FACILITY_ID defines the facility of a location group. RT_MTH_ANL_GROUP.FACILITY_ID defines the facility of an analyte group. RT_GROUP.FACILITY_ID is not used to define the facility of a location group, because it is used for other purposes e.g. negative facility id referring to a facility group.
2. When all RT_GROUP_MEMBER.FACILITY_ID of a location group are not populated, the location group belongs to all facilities, and therefore will be displayed on the user interface, regardless of the facility logged in to. Similarly, if RT_MTH_ANL_GROUP.FACILITY_ID of an analyte group is not populated, the analyte group belongs to all facilities.
Note 2: If Location/Groups is Selected
1. If Location/Groups is selected, the LOC_GROUP_CODE and LOC_REPORT_ORDER columns are in the report output. Otherwise, they are not included in the report output.
Report Dependencies: There are no dependencies for this report.
File Name: EarthSoft.Reports.Library.91656.dll
Contact firstname.lastname@example.org for a direct file link.
Input Parameters: A selection made to customize the output of a report.
Input Parameter Screenshot
REPORT_RESULT_TEXT REPORT_RESULT_VALUE REPORT_RESULT_UNIT
Note: *refers to hidden parameters.
Tables: RT_GROUP, RT_MTH_ANL_GROUP, DT_BASIC_RESULT, RT_ANALYTE, VW_LOCATION
Database Type: SQL
Database Schema: Standard (no custom or add-on schemas required)
Database Version: EQuIS 6.0+
Data Requirements: N/A
Report Requirements: N/A
Output Type: IGrid
Example Output: View the example below.