The default Multi-Piece First Article reports for QC-CALC show the Out of Specification points in red, along with ** before the value. You may also want to show these values underlined. This White Paper will give step-by-step instructions on how to show Out of Spec values in red with ** and underlined.

The Report Designer

The directions shown here will test each Actual value, and if the value is out of specification, it will appear underlined. This is a lengthy process but relatively simple to accomplish.

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

2. Make a copy of the FiveStat.raw template (highlight the file, CTRL + c to copy and CTRL + v to paste within the same list) in the list, highlight the copy, and click Open. You can also use the right-click Rename functionality to rename the file before starting.
3. The Report Designer now appears on the screen.

4. Double-click on the table, and the Table Contents window will appear. Choose the Data Line tab and the “if Part_01_Used…” line in the Line Definition 1 area.

5. Now expand the Font section in the Appearance area and click on the Color line in the right column. Click the down-arrow button on the very right side of that right column, then click the Formula button and the Edit Font.Color window appears.

6. We will use the formula in the Color area as the base for the formula we will add to the Underlined area, so this is just a brief stop. Click in the box at the bottom of the screen and hit CTRL + A on your keyboard to highlight everything. Now click CTRL + C to copy this content into your clipboard. Click the Cancel button.

7. In the Table Contents screen, use the down arrow in the Underlined item area and choose the Formula item from the list.

8. In the Edit Font.Underlined screen that appears, highlight the "False" in the box at the bottom and paste (CTRL + V) the clipboard contents into the box (replacing the "False").

9. The formula that was copied from the Color area will remain the same, except the "RGB(...)" items need to be replaced with "True" and "False" values.
10. In the formula, replace any "RGB(255,0,0)" (make sure you get the parenthesis too!) with "True" and replace any "RGB(0,0,0)" with "False". Don't miss the ones at the end of the bottom line, as they may have scrolled off the right side of the screen. The "Error" at the bottom of the screen should be resolved now.

11. Click OK once the changes have been made and no error is reported in the lower section to the right of the “i".
12. Follow steps 4 through 11 for the remainder of the “if Part_02_Used…” to " “if Part_05_Used…” lines to make all parts behave the same way in the report.
13. You have now made all the necessary changes, so you can use the File > Save menu to save your changes and Exit the Report Designer.
14. You will be asked if you changed the number of parts in the table of your report. Click the No button on that screen, and you will be done.

15. If you run the MultiPiece First Article report now and use that new template, you should see any OOS values are now underlined.