Statistics: Analyte By Sample (Lithology) (12863)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Statistics Reports >

Statistics: Analyte By Sample (Lithology) (12863)

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

 

Report Type: Standard

 

Description: The old name of this report was Statistics - Analyte by Sample. 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. 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 the report of v6.6 or later includes user (pick) reports from Analytical Results and Analytical Results II.

 

File Name: EarthSoft.Reports.12863.dll

 

Language: English

 

Input Parameters: A selection you make to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Saved Analytical Results Report

Action Levels (optional)

                                               

30094-input.params.scrnsht

Contact support@earthsoft.com

for more information.

 

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

 

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

 

Database Type: SQL Server

 

Database Schema: Standard (no custom or add-on schema required)

 

Database Version: EQuIS 5+

 

Data Requirements: None

 

Report Requirements: Excel

 

Output Type: Excel/HTML

 

Example Output: View the following example.

 

30094-ex.output_zoom78

 

EarthSoft.Reports.Library._12863.AnalyticalStatisticsBySampleLithology