PQ Systems Knowledge Base

GP: Custom reports for GAGEpack

Revision Date: 2009-09-25

This page is used to help when you need a unique report in GAGEpack. We hope that some of these reports will assist you or if you still do not see what you are looking for, feel free to contact us. If you have developed a report that you think others can benefit from, please let us know and we will include the report here. Simply e-mail the report that you have developed to support@pqsystems.com along with a short description of what the report does.

Below are the customized reports that have been developed. The reports list the file name, the report description, a more detailed description as well as a sample output. If you need any report, simply select it and save it to the same report folder where the GAGEpack is configured to pull from. (This is defined under Setup, Preferences.)

Calibration Labels
Label that is automatically printed after a calibration is entered.
Barcode printed after calibration
Custom label printed after calibration
Same as standard calibration label, but includes Calibrated by

Calibration Results
Same as “Calibration Results” report, but without comments

Reports
Labels printed in 4 columns 6 rows per page
Same as Calibration Results report but with the date range of the selection criteria in the header
Same as “Calib worksheets – per number” but includes the gage calibration interval
Same as “History – per number report” but includes event name column
Custom Job gage allocation report
Custom Job gage allocation report

Custom gage labels
Custom maintenance worksheet
Summary report of other events with cost

Gage Labels
Label example with QS/ISO Document number referenced
Gage calibration with “Calibrated by” only

Detailed report descriptions, previews of each report, and the report files are given below:

 



Calibration Labels
Printed when “Print gage label after saving event” checkbox is checked in the Calibration window
*.JAS files

Note: these files must be renamed to “lbl-Std-Calib.jas” and saved to the folder where GAGEpack is configured to pull from in order to be printed when an event is saved

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
lbl-Std-Calib _Calib by & location.JAS (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.0 and 8.5

Report description:
Label that is automatically printed after a calibration is entered.

Detailed report description:
Five items on the label that is printed after a calibration event is saved.
The information that will be printed is:

Gage Number: / Calibration done by:
Next calibration date
Last calibration date
Current location

Sample output:
See file: “lbl-Std-Calib_Calib by & location.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
lbl-Std-Calib_barcode.jas (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
barcode printed after calibration

Detailed report description:
replaces existing file for label printed after calibration

Note: file must replace existing lbl-Std-Calib.jas in order to be recognized by GAGEpack

Sample output:
See file “lbl-Std-Calib_barcode.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
lbl-Std-Calib_2fields in one row.jas (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
Custom label printed after calibration

Detailed report description:
replaces existing file for label printed after calibration

Note: file must be renamed to replace existing lbl-Std-Calib.jas in order to be recognized by GAGEpack

Includes the following fields:

Calibrated:
By:
Due

Sample output:
See file “lbl-Std-Calib_2fields in one row.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
lbl-Std-Calib_withdoneby.jas (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
same as standard calibration label, but includes Calibrated by

Detailed report description:
Note: file must be renamed to replace existing lbl-Std-Calib.jas in order to be recognized by GAGEpack

Sample output:
See file “lbl-Std-Calib_withdoneby.pdf

 


 

Calibration Results
Printed by selecting Preview, Report within a Calibration Event window
*.JAS files

Note: these files must be renamed to “Cal-res.jas” and saved to the folder where GAGEpack is configured to pull from in order to be printed when an event is saved

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Cal-res - no comments.jas (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
same as “Calibration Results” report, but without comments

Detailed report description:
must be renamed to “cal-res.jas” in order to be recognized as the Calibration Results report by GAGEpack.

Sample output:
See file “Cal-res - no comments.pdf

 


 

Reports
Printed using the Reports button in GAGEpack
*.JAR files

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Calibration certificates (most recent); per number-NIST Statement.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
The Cal. certificate has added text in the 2nd paragraph

Detailed report description:
The text added is:
Std/Master identification and traceability information
This is to certify that the above instrument was inspected and calibrated by XYZ Company, Inc. using standards whose accuracy's are traceable to the National Institute of Standards and Technology (NIST), or have been derived from accepted values of natural physical constraints, or have been derived by the ratio type of transfer self calibrating techniques. Environmental controls are set using a reference temperature of 69ºF +/-2ºF and less than 60% relative humidity.

Sample output:
See file “Calibration certificates (most recent) - per number-NIST Statement.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Labels 4 x 6 - per number.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
Labels printed in 4 columns 6 rows per page

Detailed report description:
The label has the following lines

Gage number
Gage type
Current location
Last calib. date
Next calib. date

Sample output:
See file: “Labels 4 x 6 - per number.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Calibration results with date range in header.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
same as Calibration Results report but with the date range of the selection criteria in the header

Detailed report description:

Sample output:
See file: “Calibration results with date range in header.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Calibration worksheets – per number w Cal Interval.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
same as “Calib worksheets – per number” but includes the gage calibration interval

Detailed report description:

Sample output:
See file: “Calibration worksheets – per number w Cal Interval.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Due for calibration w_vendor - per number.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
Custom due for calibration report

Detailed report description:
includes the following columns:

Gage number
Past due calibration
Gage description
Model #
Serial #
Calibration Vendor
Value
Calib. due

Sample output:
See file “Due for calibration w_vendor - per number.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
External cal expenses.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
External calibration report with costs – by location

Detailed report description:
Includes the following columns:

Date of completion
Gage number
Gage description
Cost
P O number
Vendor

Sample output:
See file “External cal expenses.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
History - per number_with event name.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
same as “History – per number report” but includes event name column

Detailed report description:

Sample output:
See file “History - per number_with event name.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Job allocation with calib due date.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
Custom Job gage allocation report

Detailed report description:
Includes the following columns for each job number:

Calibration due date
Gage number
Gage type
Gage description

Sample output:
See file “Job allocation with calib due date.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Job allocation with date checked out.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
Custom Job gage allocation report

Detailed report description:
Includes the following columns for each job number:

Checked out date
Calibration due date
Gage number
Gage type
Gage description

Sample output:
See file “Job allocation with date checked out.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Labels Avery 5160 4 x 10 - per number.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
Custom gage labels

Detailed report description:
Each label contains:

Gage number
Gage type
Location
Last Calib date
Next Calib date

Sample output:
See file “Labels Avery 5160 4 x 10 - per number.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Maintenance worksheets - per number.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
Custom maintenance worksheet

Detailed report description:
Includes the following fields:

Event name:  
Entered by: Date:
Done by: Condition of gage:
Cost: Time:
Status: Location:
UserField1: UserField2:
Notes:  

Sample output:
See file “Maintenance worksheets - per number.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Summary Other events expenses; per type.jar (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Report description:
Summary report of other events with cost

Detailed report description:
Includes the following columns:

Gage number
Name
Cost
Time
Date of completion
Current location

Sample output:
See file “Summary Other events expenses; per type.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

Report name:
Calibration certificates (most recent) - per number - custom1.jar

Version Supported:
GAGEpack 8.0 and 8.5

Report description:
Standard Calib. Certificate (most recent) – by number, but without asset # or NIST number

Detailed report description:
Includes:

Number
Location
Item name
Accuracy
Model

Sample output:
See file “Calibration certificates (most recent) - per number - custom1.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Calibration certificates (most recent) - per number – custom2.jar

Version Supported:
GAGEpack 8.0 and 8.5

Report description:
Custom Calib. Certificate (most recent) – by number

Detailed report description:
Standard Calib. Certificate (most recent) – by number, but without asset # or NIST number

Includes additional table with Serial Number, Gage ID, Last Calibration date, and Calibration due date.

Sample output:
See file: “Calibration certificates (most recent) - per number – custom2.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Calibration certificates (most recent) - per number – custom3.jar

Version Supported:
GAGEpack 8.0 and 8.5

Report description:
Custom Calib. Certificate with calibration time

Detailed report description:
Same as Calibration certificates (most recent) by number, but includes Uncertainty, Resolution, and Calibration time

Sample output:
See file: “Calibration certificates (most recent) - per number – custom3.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Calibration results (with Date Range in Header).jar

Version Supported:
GAGEpack 8.0 and 8.5

Report description:
Calibration results gage summary

Detailed report description:
Includes the following columns:

Calib. Date
Step name
Target value
As found
After adj.
Deviation

Sample output:
See file: “Calibration results (with Date Range in Header).pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Job gage allocation - by date.jar

Version Supported:
GAGEpack 8.5

Report description:
Job gage allocation report – range of dates

Detailed report description:
Contains created on and job number for each gage for a range of dates and gages

Sample output:
See file: “Job gage allocation - by date.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Calibration worksheets - per number - with procedure.jar

Version Supported:
GAGEpack 8.0 and 8.5

Report description:
Standard calibration worksheet with calibration procedure

Detailed report description:
Contains: Gage number, Current location, Description, Gage size, Due for calibration, Master gages, Date of calibration, Cost of calibration, Calibrated by, Results, Calibration procedure, and table of results

Sample output:
See file: “Calibration worksheets - per number - with procedure.pdf” 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Due for Calibration with Gage Size.jar

Version Supported:
GAGEpack 8.5

Report description:
Similar to Due for calibration; per location but with Gage Size, Serial Number and no Interval.

Detailed report description:
The label has the following lines

Gage number
Calib Te
Serial number
Gage size
Gage type
Gage description
Calib. due date

Sample output:
See file: “Due for Calibration with gage size.pdf





 

Gage Labels
Printed using the Labels button in GAGEpack
*.JAL files

Report name:
Lbl-num24Comar.jal (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.0

Report description:
Label example with QS/ISO Document number referenced

Detailed report description:
The label has the following lines:

Calib Date
Done by
Next Calib.
Gage number
A text field.

Sample output:
See file: “Lbl-num24Comar.pdf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Report name:
Calibration label - per number - Calibrated by.jal (Right click and select "Save Target As" [IE] or "Save Link As" [Firefox])

Version Supported:
GAGEpack 8.5

Report description:
Gage calibration with “Calibrated by” only

Detailed report description:

Sample output:
See file “Calibration label - per number - Calibrated by.pdf


Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions (1 vote)

100% thumbs up 0% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Related Articles

No related articles were found.

Attachments

No attachments were found.

Continue