SPM - Labels Report

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

Plan Code	Parameter to select the sample plan code. Only plans with applicable tasks are shown.
Date Range
Start	Select a start date.
End	Select an end date.
Task Code(s)	Parameter for selecting task code(s).
Lab(s)	Parameter for selecting lab(s).
Analyte Groups	Parameter selection for analyte groups.
Custom Text	Input box for custom text.
Custom Text 2	Input box for custom text.
Output File Type
Avery Pro Designer	Output file type for Avery Pro Designer: dbf or Excel.
MS Word Template	Select a Microsoft Word template. This will overwrite the Excel output if selected above. Refer to the Create an MS Word Template article and Import COC Template for COC Report article for information on how to add a template. Note on Step 10, DT_FILE.PLACE_TYPE must be "labels" for the template to be added to the parameter list. An example file is supplied with EDGE in .\EDGE\Custom Labels\EDGE_Labels5163.docx. This is only an example. See below for a list of available Field Labels that can be used in the template.
PDF Output	Check box for PDF output. Default: True.

The template file for SPM - Labels report can include the below available fields. Limited fields can be used in the SPM – Labels (Custom) and SPM – Labels (Custom2). These are annotated in the below list with an asterisk (*).

Field Label	EDD/EDP Table	Column
company*	DT_SPM_SCHEDULED_SAMPLE*	SAMPLING_COMPANY_CODE* *This field is only available for the Custom reports
Cont_id	DT_SPM_SCHEDULED_CONTAINER	First non-null: CONTAINER_ID, CONTAINER_ID_SHARED
cont_type	DT_SPM_SCHEDULED_CONTAINER	CONTAINER_TYPE
contCount*	DT_SPM_SCHEDULED_CONTAINER	Count of NUMBER_OF_CONTAINERS
contTotal*	DT_SPM_SCHEDULED_CONTAINER	Total of NUMBER_OF_CONTAINERS
custom*	Custom Text report parameter
custom_2	Custom Text 2 report parameter
facility*	DT_FACILITY	FACILITY_CODE
filtered	AT_SPM_CONTRACT_MTH_CONTAINER	FILTERED
fraction	DT_SPM_SCHEDULED_RESULT	TOTAL_OR_DISSOLVED
hold_yn	DT_SPM_SCHEDULED_RESULT	HOLD_YN
id	DT_SPM_SCHEDULED_CONTAINER	FACILITY
lab	DT_SPM_CONTRACT	CONTRACTOR_CODE
loc_name	DT_LOCATION	LOC_NAME
location*	DT_SPM_SCHEDULED_SAMPLE	SYS_LOC_CODE
MAG*	DT_SPM_CONTRACT_MAG	•First non-null: REMARK, METHOD_ANALYTE_GROUP_CODE •Labels (Custom) and Labels (Custom2) - Value of the new Mag Field parameter
MAG_ID*	DT_SPM_CONTRACT_MAG*	SPM_CONTRACT_MAG_ID* *This field is only available for the Custom reports
matrix*	DT_SPM_SCHEDULED_SAMPLE DT_SPM_CONTRACT_MAG*	PRESERV MATRIX_CODE* used for the Custom reports
Method*	DT_SPM_CONTRACT_METHOD	ANALYTIC_METHOD
nbofCont*	DT_SPM_SCHEDULED_CONTAINER	SAMPLE_MATRIX_CODE
preserv	DT_SPM_CONTRACT_CONTAINER	PRESERVATIVE
sampleid*	DT_SPM_SCHEDULED_SAMPLE	SYS_SAMPLE_CODE
sampler	DT_SPM_SCHEDULED_SAMPLE	SAMPLER
sampleType	DT_SPM_SCHEDULED_SAMPLE	SAMPLE_TYPE_CODE
task*	DT_SPM_SCHEDULED_SAMPLE	SCHEDULED_TASK_CODE
tat_days	DT_SPM_CONTRACT_METHOD	MAX_TURNAROUND_DAYS

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.