Change a Trace Field Column in an ERS Raw Data Report - 4.2
Steps to modify a trace field column in a raw data report
Print Friendly View
written: 08/06/2024
last modified: 11/11/2024

In this tutorial, you will learn how to modify an existing ERS Raw Data Report template to change a text trace field so that the report prints a different trace field. This will be useful if you have standardized trace fields in specific positions across different part files.

Preparation

First, we will make a copy of an existing template file to edit. Next, we will use QC-CALC Real-Time to look up the trace field position numbers for the trace fields you want to include in the report template. Finally, we will make the necessary changes to modify a column of trace fields.


Check Trace Field Positions in QC-CALC

Trace fields are referred to by variables in the Report Designer such as trace_text_value_01. To make sure you use the correct variables for the trace data you need, you can look up these trace field position numbers in QC-CALC Real-Time:

  1. In QC-CALC Real-Time, to open the part file for which you are creating the report template, go to File > Open and select the file you need.
  2. Go to File > Properties... > Edit Nominals & Tolerances.
  3. In the window that opens, look in the Trace Fields sections in the list on the left. You may have to scroll to the bottom of that list to find them.

image.png

  1. Note the number in parentheses next to the trace fields, you will need to know these for the Report Designer.


Editing the Template

  1. In ERS go to Report > Design Templates

image.png

  1. ERS will prompt you to select a report template. Choose RawDataStats.rdr and select Open.
  2. Now the Report Designer window will open with the selected report template

image.png

  1. Go to File > Save As to save the template file with a new name so you don't modify the original template
  1. Select the Projects tab in the Objects pane on the top left side of the Report Designer window
  1. Double-click on the "Table: part" section in the Table of Contents list in the upper left to open the editor window

image.png

  1. To change a single column of trace fields you must make two changes, one in the Header Line and one in the Data Line.
  1. With the "Table Contents - part" window open select the Header Line tab

image.png

  1. Notice the lines ending in trace_text_label_## under "Line Char Labels". These are the names of the trace fields that prints at the top of each column. Let's say text trace field 01 is Serial Number in your data but you want to see Operator (text trace field 03) in that column, instead.
    First, double-click to edit one of the trace field lines and that will open an editing window.
  1. Change the 2-digit number on the end to the value you need based on what you saw in QC-CALC Real-Time (steps 1-3)

image.png

  1. Select OK to close the editing window when finished.
  1. After making the change to the Header Line click on the Data Line tab

image.png

  1. On the Data Line, you'll need to make the same change to the same trace field line. Notice the formula is the same except the variable being used is trace_text_value rather than trace_text_label. This is what will print the values for your trace field.

image.png

  1. Once finished, select OK to close the editing window
  2. Back in the main window of the Report Designer, go to File > Save or click the image.png button to save your template
  3. You can now close out of the Report Designer and then go to Report > Print Report to select your Raw Data template and print a report.

image.png

Category

Reporting - Enterprise Report Scheduler
See more articles in this category