WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login
Search the WinSPC Knowledgebase Browse by Category
Certificate of Analysis Report With Tag Values
Article Details

Last Updated
29th of July, 2016

Applies to
WinSPC 8.0, WinSPC 8.1, WinSPC 8.2, WinSPC 8.3, WinSPC 9.0

This report will produce a Certificate of Analysis (COA) style report (similar to existing COA reports in WinSPC), but will also contain a list of tag names and unique tag values at the top of the report.  The report will combine the tag values for each of the variables into a comma separated list of unique tag values.  This report can be useful if you are filtering your underlying dataset by one tag value (such as "Order Number"), but want to see a list of all the "Serial Numbers" that were entered as tag values for that particular "Order Number".

An example of the report is shown here (in this example, the user filtered the underlying data to a specific "Customer Order Number"):

coawithtags2.jpg

This report will produce 1 page per WinSPC part that is contained within the underlying dataset or object the report is executed on.  If the part contains more than 40 variables, multiple pages will be produced for a single part, but a single report page will only show information regarding a single part.  Please note that if multiple report pages are produced for a single part, the list of tag values at the top of the page will only represent the tag values associated with the variables shown on that page of the report.

There are also some available options to add some color to the report.  The following options are available:
  • Add 'gray banding' to allow for easier reading of the rows.  This will alternate gray/white graphical bands every group of 3 variables (the first three variables will have a gray background, the next 3 will have white, etc.).
  • Color the values in the 'Cpk' according to its value.  Cpk values less than 1.00 will be red, values between 1.00 and 1.33 will be yellow, and values greater than (or equal to) 1.33 will be green.
  • Color the values in the 'Cp' column (according to the same rules for the Cpk coloring).
  • Color the values in the 'Ppk' column (according to the same rules for the Cpk coloring).
  • Color the values in the 'Pp' column (according to the same rules for the Cpk coloring).
These options can be turned on or off in the report template properties, as seen here:

coawithtagsoptions.jpg

To turn a color option on or off, open up the properties of the report template, click on the checkbox next to the 'True'/'False' text for the item and then click "OK" to save the report template.

A couple sample outputs of the report can be seen by downloading the PDF attachments below. 

To use this report template, simply download the report template export ("COA (with tags).exp") corresponding to your current version of WinSPC from the attachments below and import the template into your WinSPC system.
Attachments
Related Articles
Visitor Comments
  1. Comment #1 (Posted by Anonymous)
    Downloaded it but it doesn't import. I'm using WinSPC 9.0.2 [TECH] Need to download the template for version 9, not the one for version 8
Post Comment for "Certificate of Analysis Report With Tag Values"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Your Name:
   Email Address:
* Your Comment:
* Enter the code below:
 

All Content 2012 DataNet Quality Systems. All Rights Reserved.