Bottle Request (Group by Lab)

Report Name: SPM - Bottle Request (Group by Lab) (example)

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1

Description: The Bottle Request (Group by Lab) report summarizes the containers required for the selected task(s) and exports an Excel file that can be used to request the appropriate containers from the labs.

Installation Instructions: This report requires a licensed SPM and the SPM Schema applied to the database.

•For SPM usage, no additional steps are necessary.

•For Enterprise usage, this report should be published to the database. The report will be available for selection once it has been published.

•For Professional usage, this report should be published to the database or have the .dll added to the local '.../Earthsoft/EQuIS/' folder.

Overview: This report requires Plan, Contract, and scheduled Task to be created in SPM. Container information must be included in Contract information.

Source Tables DT_FACILITY, DT_FIELD_SAMPLE, DT_LOCATION, DT_LOCATION_PARAMETER, DT_PURGE, DT_RESULT, DT_SAMPLE, DT_SOIL_GAS_SURVEY, DT_SPM_CONTRACT, DT_SPM_CONTRACT_CONTAINER, DT_SPM_CONTRACT_MAG, DT_SPM_CONTRACT_MAG", DT_SPM_CONTRACT_MAG", DT_SPM_CONTRACT_METHOD, DT_SPM_PLAN, DT_SPM_SCHEDULED_ACTIVITY, DT_SPM_SCHEDULED_CONTAINER, DT_SPM_SCHEDULED_RESULT, DT_SPM_SCHEDULED_SAMPLE, DT_SPM_SCHEDULED_TASK, DT_SPM_SCHEDULED_TASK, DT_TASK, DT_TEST, DT_WATER_LEVEL, RT_ANALYTE, RT_COMPANY, RT_GROUP, RT_GROUP_MEMBER, RT_LOOKUP, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP", RT_SPM_ACTIVITY

Input Parameters

Plan Code	Select a plan (only plans with applicable tasks are shown).
Task Filter	Select one or more tasks.
Date Range
Start	Select a start date.
End	Select an end date.
SPM Task Code(s)	Parameter for selecting SPM task code(s).
Lab (required)	Required parameter for selecting the lab.
Include Location and Samples	Toggle to include locations and samples in the report output. Default: True.

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