Statistics: Analyte By Sample (Lithology)

Report Name: Statistics - Analyte by Sample (Lithology) (example)

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

Dependencies: Saved Analytical Results report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

Description: This report creates a Crosstab Report in Microsoft Excel that displays lithology samples down the side, and analytes across the top. Below the crosstab are summary statistics for each analyte.

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

Overview:

The report can also report action level violations if the Action Level input is selected. If a sample value or a statistical value (Minimum, Maximum, etc.) is greater than an action level value, the value is highlighted. Up to four (4) action levels can be used in the report. Note that some samples may not be reported in the output results if the report is used for non lithology related samples. The list of the Saved Analytical Results II or Analytical Results Report: parameter in this report includes user reports from Analytical Results and Analytical Results II. The required input parameter for this report is a Saved Analytical Results Report. Specific Action levels may also be chosen as well as the option to use non-detects.

Tables: All tables used by the Analytical Results Report and DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, ST_REPORT, ST_USER_REPORT, VW_LITHOLOGY

Report Parameters

Saved Analytical Results Report	Select a saved Analytical Results user report.
Action Level(s)	Parameter for selecting action levels.
Use non-detects	Parameter to use non-detects. Default: true

Note: If the report does not generate output, then run VW_LITHOLOGY and make sure VW_LITHOLOGY.END_DEPTH is populated.

1Excel report output requires a valid license of Microsoft Excel to view the output.