Analytical Results II with Location Parameters

Report Name: Analytical Results II with Location Parameters (example)

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

Dependencies: Analytical Results II and Location Parameters (Extra Fields)

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: Analytical Results II with Location Parameters runs the Analytical Results II (ARII) and Location Parameters (Extra Fields) and combines the output rows.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary. For use in EQuIS Enterprise, the report must be published to the database via EQuIS Professional, and the Location Parameters (Extra Fields) report DLL (EarthSoft.Reports.Library.65991.dll) must be added to the Enterprise bin folder.

Overview: The report appends each output row of Location Parameters (Extra Fields) to ARII output. The data mappings from the Location Parameters (Extra Fields) columns to those of Locational Analytical Results II are:

Report Parameters

Location	Location Parameters (Extra Fields)
SAMPLE_DATE	MEASUREMENT_DATE
ANALYTIC_METHOD	MEASUREMENT_METHOD (by default, or users can undo the remap)
LAB_QUALIFIERS	FLD_QUALIFIER (by default, or users can undo the remap)
REPORT_RESULT_VALUE	PARAM_VALUE
REPORT_RESULT_TEXT	PARAM_TEXT
REPORT_RESULT_UNIT	PARAM_UNIT
CAS_RN	PARAM_CODE
CHEMICAL_NAME	RT_LOCATION_PARAM_TYPE.PARAM_DESC, or PARAM_CODE
Additional Fields with same names	Additional Fields with same names
	Additional Fields with the names not existing in ARII*

*Note when Additional Fields of Location Parameters (Extra Fields) report are selected and do not exist in the output of ARII, they are
simply added to the final output.

Hidden Parameters: Two hidden parameters are shared by the Analytical Results II and Location Parameters (Extra Fields) base reports: @facility_id and @ebatch. Additionally, there are two new hidden parameters of "Map measurement_method to analytic_method:" and "Map fld_qualifier to lab_qualifiers" so that users can choose if they want to map measurement_method and fld_qualifier to the analytic_method and lab_qualifiers of the Analytical Results II output.

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