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*

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

•ebatch

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.

*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: The Analytical Results II and Location Parameters (Extra Fields) base reports share two hidden parameters: @facility_id and @ebatch. Additionally, there are two new hidden parameters, "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.