SPM - Labels

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports by Module > Standard with Sample Planning Module >

SPM - Labels

Report Name: SPM - Labels (example)

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1, DBF or PDF

 

Description: Generates a Microsoft Excel, DBF or PDF file of sample labels with assigned containers, and generates information for samples that have container information.

 

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 use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

 

Overview:

 

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 DBF/Excel output.

PDF Output

Checkbox for PDF output. Default: True.

 

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.