Adding a Column of Factors to the Raw Data Report
Step-by-step instructions for adding a column of text factors to a Raw Data Report template
Print Friendly View
written: 11/19/2007
last modified: 04/10/2024

The default Raw Data reports with QC-CALC do not show any columns of factor values at the start. This White Paper will give step-by-step instructions for designing a custom template and adding a column of "Text Factor 1" values to one of the standard Raw Data templates.

The Report Designer

The directions shown here will replace the report's 10th column of dimension information with a value saved in Text Factor 1. This is a lengthy process, but relatively simple to accomplish.

  1. From QC-CALC Real-Time choose the Report – Design Template menu.

  1. Choose the DataStat.raw template from the list of files that appears and click Open.
  1. The Report Designer now appears on the screen.
  1. Double-click on the table and the Table Contents window will appear.

  1. Choose the Header Line tab, double-click the “Dim_Label_10” line in the Line area, and the Edit Table window appears.

  1. Highlight the “Dim_Label_10” in the box at the bottom, then open the Fields list at the top of the screen.
  1. Scroll down the Fields list until you find the “Text_Factor_1_Label” item, highlight it, and click the Insert button to the right.

  1. Click the OK button on the Edit Table window.
  1. On the Table Contents window, choose the “Line Definition 2 – Nominal” item at the top of the Header Line tab.

  1. Double-click the “if(Used_Dim_10,…” line to get to the Edit Table window for this line.
  1. In the Edit Table window, highlight and delete the entire “if(Used_Dim_10,…” line towards the bottom of the window, enter “ “ (quote space quote) in that area as shown below, then click OK.

  1. On the Table Contents screen, click the plus sign (+) to the left of Background in the Appearance area. Change the Background option to “True”, then choose “RGB(192,192,192)” for the Color.

  1. Follow steps 9 – 12 for the “Line Definition 3 – USL” and “Line Definition 4 – LSL” items.

Data Lines

  1. Still in the Table Contents window choose the Data Line tab, then double-click the “if(Used_Dim_10,…” line to get to the Edit Table window for this line.
  1. Delete everything in the box at the bottom, then scroll down in the Fields list a the top of the screen until you find the “Text_Factor_1” item.

  1. Highlight “Text_Factor_1” in the Fields list, click the Insert button, and then click OK.

Footer Lines

  1. Back in the Table Contents window choose the Footer Line tab.

  1. Choose “Line Definition 2 – Mean” at the top of the screen then double-click the “if(Used_Dim_10,…” line to open the Edit Table window for this line.
  1. In the Edit Table window, highlight and delete the entire “if(Used_Dim_10,…” line towards the bottom of the window, enter “ “ (quote space quote) in that area as shown below, then click OK.

  1. Back on the Table Contents screen, click the plus sign (+) to the left of Background in the Appearance area. Change the Background option to “True”, then choose “RGB(192,192,192)” for the Color.

  1. Follow steps 2 – 4 for the following items:
    “Line Definition 3 – Max”
    “Line Definition 4 – Min”
    “Line Definition 5 – Range”
    “Line Definition 6 – Sigma”
    “Line Definition 7 – Cpk”

General Steps

  1. Click OK on the Table Contents screen and save your changes (File – Save).
  1. Exit from the Report Designer and you will see a question asking if you changed the number of dimensions in your report. Choose Yes on this message.

  1. The next window will ask for the total number of dimensions this report represents. Answer this question with “9” so that your report will run correctly in the future.

Applies To

QC-CALC Real-Time v.3.20
QC-CALC Real-Time v.3.00
QC-CALC SPC v.3.20
QC-CALC SPC v.3.00

Category

Reporting - QC-CALC 3.x
See more articles in this category