The Data tab of the Excel Form Report dialog box (Insert | Report Command | Excel Form Report) lets you select dimensions that you want to report in the Excel Form and set the values of custom fields for each dimension.
Excel Form Report dialog box - Data Tab
The Data tab displays the list of dimensions in their order of measurement. The tab also displays the Report, PCD ID, Nominal Value, and custom field columns. There may be more than one custom field columns based on what you created and associated in the Form tab. The PCD ID and Nominal Value columns identify the dimensions. You cannot edit the values.
In the search box, you can type the PCD ID to search for a dimension.
From the list, in the Report column, mark the check box next to each dimension that you want to see in the report.
Report All - This option reports all of the features in the report.
Report Out of Tolerance Only - This option reports only out-of-tolerance features in the report.
Report In Tolerance Only - This option reports only in-tolerance features in the report.
Report Last Execution Data
(
) - This toggle button
lets you decide whether to report the last execution data. You can also
turn on this option when you measure features that are in loops. For dimensions
that you want to measure in loops, you must first execute the measurement
routine before you can type values into custom fields. After you execute
the measurement routine, you can turn on this option to see the dimensions.
Re-Order Dimensions
You can create a custom order of dimensions. To do
this, you need to first click the Set custom order
button (
). Then, right-click
on any dimension to access the following options to re-order the dimensions:
Move - This option moves one dimension at a time.
To do this, follow these steps:
Select a row of dimensions.
Click on the selected row.
Drag the dimension to the desired location.
You can also use Alt + Up Arrow or Alt + Down Arrow to move selected items up or down.
Move to Top - This option moves the dimension to the top of the list.
Move to Bottom - This option moves the dimension to the bottom of the list.
To do this, follow these steps:
Select one or more multiple rows of dimensions.
Select the dimension. To select multiple non-consecutive dimensions, press Ctrl and click the dimensions. To select consecutive dimensions, press Shift and click the first dimension; and then click the last dimension in the sequence.
Select Move to Top or Move to Bottom to move the selected dimensions to the top or bottom of the list.
Move and Move Here - These options together can help you to move dimensions between pages in a measurement routine with a large number of dimensions.
To do this, follow these steps:
Select one or more dimensions.
Right-click on the selected dimensions and select Move. This marks the selected dimensions to move.
Select the dimension above which you want to insert the marked dimensions from step 2.
Right-click on the selected dimension and select Move Here. This inserts the dimensions that you selected in step 1.
Sort by Measure Order - This option resets the list of dimensions to the original measured sequence.
Sort by Last Saved Order - This option resets the list of dimensions to the last saved sequence of dimensions. When you edit the sequence of dimensions and create the command, PC-DMIS saves the updated sequence of dimensions.
The check boxes for each dimension under the Report column lets you select the dimension that you want to see in the Excel Form Report. All of the dimensions are selected by default.
To select specific check boxes, follow these steps:
Click the check box to the left of the Report column heading to clear all check boxes.
Select the check box of each dimension that you want to see in the Excel Form Report command.
Custom Field Columns
The custom field columns display the columns for the custom fields that you have associated in the view area of the Form tab.
If a custom field has a single value, the column displays a text box for each dimension. Type the text that you want to set for each dimension.
If a custom field has multiple values, the column displays a list for each dimension. The selected value in the Custom Field dialog box is the default value. Select the value that you want to set for each dimension.
For more information about the custom fields, see "Custom Fields".