Labels

<< Click to Display Table of Contents >>

 >EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with Sample Planning Module >

Labels

Report Name: SPM - Labels

 

Report Type: Standard with Sample Planning Module purchase

 

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

 

File Name: EarthSoft.Reports.Library.48827

 

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

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Plan Code


Date Range



Start


End

Task Code(s)


Lab(s)


Analyte Groups


Custom Text


Custom Text 2


Output File Type


                                               

label_report_parameter

Note: * refers to hidden parameters

 

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

 

Database Type: SQL

 

Database Schema: Sample Planning Module (SPM)

 

Database Version: Contact support@earthsoft.com for more information.

 

Data Requirements: N/A

 

Report Requirements: Excel

 

Output Type: DBF or Excel

 

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.

 

Example Output:

 

In Avery Design and Print Online:

 

spm_labels_output_Avery