Symptom:

Reports displaying barcode data from the Parts table are inconsistent or incorrect. This issue has a different cause than when a Part Label displays incorrect face 5 or face 6 barcode data. Click here for more information about that issue.

Cause: 

Build 15.6 contains an expanded ability to process with multiple single parts processing stations. One of the reasons for this is that a User may want to direct the parts to one of the several CNC machines to equalize the workload of those machines.

When processing with multiple single parts processing stations, previously, the program would populate the barcodes to the Parts table only for the last station of multiple stations processed. This is because that table has only a single field for the barcode data. The Parts table design does not support optimized data produced by multiple stations.

Build 15.6 now makes it possible to obtain the correct barcode data in the report when using multiple stations but to support that change, the single parts barcode data is now populated to the OptimizationResults table instead of the Parts table.

Resolution:

Here is a tutorial for modifying the default “Parts Select Processing” report to consume the data populated to the new location. The procedure for custom reports will be similar, depending on the report structure.

1. Open Toolbox and click: “Toolbox Setup > Design Reports > Design Manufacturing Report > New Report From Existing” select the report to use as the template for the new report.
   
2. In the Report Setup screen, name the report as needed. Click the options button for “Microvellum Work Order” and make sure there is a checkmark next to OptimizationResults. Lastly, set the property “Is Batch Report” to True and click OK.
   


Fig. 1



3. Add a database relationship with OptimizationResults as the child table, and Parts as the parent table.
   
1. Click the Dictionary tab in the lower right corner of the report designer.
   
2. Right-click the dataset table for OptimizationResults and click “New Relation.”
   


Fig. 2



3. Enter the text string “Parts-OptimizationResults” as the property Name in Source.
   
4. Enter “Parts” as the property for Name and Alias.
   
5. Select “Parts” for the Parent DataSource property. The property for Child Data Source should already contain “OptimizationResults” if the steps above were correctly completed. 
   
6. Double-click “LinkID” from the right column of Parent Columns and verify that it is correctly populated to the left side of that same section.
   
7. Double-click “LinkIDPart” from the right column of Child Columns and verify that it is correctly populated to the left side of that same section. 
   
8. Verify that your screen matches Figure 3 below.  
   


Fig. 3

4. Modify the databand definition of the table Parts to be OptimizationResults.
   
1. Double-click the databand defined as Parts and click the tab Data Source.
   
2. Double-click the dataset table OptimizationResults.
   
5. Modify all text component expressions or data columns, databand group condition expressions or data columns, event code, and databand filter expressions to include the new relationship to OptimizationResults. See the examples below, contact Microvellum to arrange for Remote Services in making these modifications.
   
1. GroupHeader condition: {Parts.Name} Modify To: {OptimizationResults.Parts.Name}
   
2. Text component expression displaying cut part length: {IIF(Parts.AdjustedCutPartLength <> Nothing, MVValueFormat(Parts.AdjustedCutPartLength), MVValueFormat(Parts.CutPartLength))} Modify To: {IIF(OptimizationResults.Parts.AdjustedCutPartLength <> Nothing, MVValueFormat(OptimizationResults.Parts.AdjustedCutPartLength), MVValueFormat(OptimizationResults.Parts.CutPartLength))}
   
3. Master Cut Report GroupHeader2 BeforePrint event code: varQtyItemNumberString = Me.varQtyItemNumberString + " #" + Parts.Products.ItemNumber + "(" + (Totals.Sum(GroupHeader2, Parts.Quantity) * Parts.Products.Quantity).ToString + ")" Modify To: Me.varQtyItemNumberString = Me.varQtyItemNumberString + " #" + OptimizationResults.Parts.Products.ItemNumber + "(" + (Totals.Sum(GroupHeader2, OptimizationResults.Parts.Quantity) * OptimizationResults.Parts.Products.Quantity).ToString + ")" 
   
6. Click the Preview tab. Evaluate “Warnings,” “Information Messages,” and “Report Rendering Messages” for significance and correct as necessary. Correct any “Errors!”
   
7. Save the report using the small Save button in the extreme upper left corner of the report designer.   
   

Updated default reports may be downloaded from the Downloads area of the Microvellum Knowledge Base.