<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM > SPM - Labels Reports |
Report Names: SPM - Labels (example), SPM – Labels (Custom) (example), SPM – Labels (Custom2) (example)
File Name: EarthSoft.Reports.Library.48827.dll
Dependencies: Licensed SPM and SPM Schema
Software: SPM
Source: SPM install
Language: English
Output Type: Excel1, Word2, DBF or PDF
Description: Generates a Microsoft Excel, Microsoft Word, DBF or PDF file of sample labels with assigned containers, and generates information for samples that have container information. The output is grouped by SYS_SAMPLE_CODE and then sorted by CONTAINER_ID.
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: The reports generate a collection of columns relevant to container labels that can be included in a labels template. Each report also generates a couple of barcodes that can be included in the label template, as follows:
•SPM – Labels includes a choice of Barcode or QRBarcode for SYS_SAMPLE_CODE
•SPM – Labels (Custom) includes a choice of Barcode or QRBarcode for SYS_LOC_CODE
•SPM – Labels (Custom2) includes a Barcode for SYS_LOC_CODE and one for SYS_SAMPLE_CODE
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
Report Parameters |
||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
The DBF file can be used in Avery DesignPro 5. Open a blank project from scratch for any label of your choice, then create the label template from the Database > Open button. Database > Display records will then create the label based on this template and the DBF output.
The Excel file can be used in Excel, Avery Design and Print or Avery Design and Print Online. Enter the Avery product ID to get started, choose the 'import data' option, then follow the prompts.
1Excel report output requires a valid license of Microsoft Excel to view the output.
2Word report output requires a valid license of Microsoft Word to view the output.
Copyright © 2023 EarthSoft, Inc • Modified: 14 Jul 2022