Analytical Results Crosstab (Chemicals by Location) (19846)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results >

Analytical Results Crosstab (Chemicals by Location) (19846)

Report Name: Analytical Results Crosstab (Chemicals by Locations) (19846)

 

Report Type: Standard

 

Description: This report creates a Crosstab Report in Excel that displays location, sample date and sample type as column headers, and chemicals as row headers.

 

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

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual(s)



Group(s)


Sample




Type(s)



Date Range




Start Date



End Date

Matrix(es)



Task(s)



Delivery Group(s)



Depth




Minimum Start Depth



Maximum Start Depth



Unit


Test




Method(s)



Fraction(s)



Column Number(s)



Type(s)



Lab Matrix(es)



Prep Method(s)


Result




Analyte




Group(s)


Unit



Type(s)



Detect Flag(s)



Non-Detect Multiplier



Non-Detect Symbol



Reportable



Reporting Limit


30155-input.params.scrnsht

SYS_LOC_CODE

X_COORD

Y_COORD

METHOD_ANALYTE_GROUP

CAS_RN

CHEMICAL_NAME

COUNT

MINIMUM

AVERAGE

MAXIMUM

SUM

UNIT

 

Tables: RT_GROUP, RT_MTH_ANL_GROUP

 

Database Type: SQL

 

Database Schema: Standard (no Custom or add-on schemas required)

 

Database Version: EQuIS 5.5+

 

Data Requirements: Excel

 

Report Dependencies: Analytical Results

 

Report Requirements: Excel

 

Output Type: Excel

 

Example Output: View the following example.

 

30155-ex.output-analytical.results.crosstab.chemicalbylocation