Analytical Survey Results

<< Click to Display Table of Contents >>

Analytical Survey Results

Report Name: Analytical Survey Results

 

Report Type: Alive Standard Report

 

Description: The Analytical Survey Results Report combines the Analytical Results with Survey Results (Survey Types) Reports into one report. An additional parameter allows you to define how the data is combined in the output. Details about the Analytical Results portion of the report, and the Survey Results (Survey Types) portion are found in the following help articles.

 

Analytical Results II Report

Survey Results (Survey Type)

 

Warning for Enterprise Use: The EarthSoft.Reports.Library.77486.dll must be in the Enterprise bin folder for this report to run in EQuIS Enterprise.

 

Report Dependencies: EarthSoft.Reports.Library.50943.dll and EarthSoft.Reports.Library.77486.dll

 

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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

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

 

These are the same as the input parameters for the Analytical Results Report and the Survey Results (by Survey Type) Report, except for one parameter.

 

Input Parameters

Input Parameter Screenshot

Join By:

 

 

                                               

30280-input_param_scrnsht

 

 

In this report, it is also possible to filter by additional fields. Learn how in the help article Analytical Results II - How To - Add Parameter Selection.

 

Sample: Will link observations to samples based on AT_SAMPLE_OBSERV. More information on AT_SURVEY_OBSERV is found in the help article Database - Linking Samples to Observations.

 

Location: Will link survey data to analytic data, based on locations that belong to the survey's subfacility. This link is made in at_subfacility_location.

 

Tables: AT_SUBFACILITY_LOCATION, DT_SAMPLE, DT_TEST, DT_RESULT, RT_ANALYTE, DT_COORDINATE, VW_LOCATION, DT_SURVEY, DT_SURVEY_PARAM, DT_SURVEY_OBSERV, DT_SURVEY_OBSERV_PARAM, RT_SURVEY_TYPE, RT_TAXONOMY, DT_SUBFACILITY, DT_SPATIAL_EXTENT

 

Database Type: SQL

 

Database Schema: Standard, Alive

 

Database Version: EQuIS 6.3+

 

Data Requirements: N/A

 

Report Requirements: Microsoft Excel

 

Output Type: Microsoft Excel

 

Example Output: View the following example or download this file.

 

30280-ex_output