We have streamlined the way information for labels and reports is processed to improve accuracy and efficiency. Part image rotation, filenames, barcodes, edge boring(Hbore), and edgebanding location data are all now accessed from the OptimizationResults table directly. This means you will no longer need part transformation functions to accurately display data on Microvellum generated part labels and reports.
Update Existing Labels and Reports
After updating to build 21.1.0604.641, your existing labels and reports may need to be updated by following the steps below.
Be sure to save a copy of your report or label before making any changes.
The following steps require some prior knowledge and experience modifying reports. Click here to learn more about working with reports.
First, set your labels and reports to look directly to the OptimizationResults table for the part information fields listed below:
Read this table left to right. The left column is the formula to use now. The right column is the older part transformation function it replaced. If your label or report contains anything from the right column, replace it with the entry beside it on the left.
Updated Formula | Prior Part Transformation Reference |
OptimizationResults.WMFStream | |
OptimizationResults.WMFStreamFace6 | |
OptimizationResults.Face5FileName | MVFace5FileName |
OptimizationResults.Face6FileName | MVFace6FileName |
OptimizationResults.Face5Barcode | MVFace5Barcode |
OptimizationResults.Face6Barcode | MVFace6Barcode |
OptimizationResults.EBLeftRotated | MVEdgeBandLeftRotated |
OptimizationResults.EBRightRotated | MVEdgeBandRightRotated |
OptimizationResults.EBBottomRotated | MVEdgeBandBottomRotated |
OptimizationResults.EBTopRotated | MVEdgeBandTopRotated |
OptimizationResults.EdgeBoreLeftRotated | MVHBoreLeftRotated |
OptimizationResults.EdgeBoreRightRotated | MVHBoreRightRotated |
OptimizationResults.EdgeBoreBottomRotated | MVHBoreBottomRotated |
OptimizationResults.EdgeBoreTopRotated | MVHBoreTopRotated |
If you see "...is not declared" in the report designer. Entering one of the right-column function names - MVFace6Barcode, MVEdgeBandLeftRotated, MVHBoreTopRotated and the rest - on a current build produces an error such as "MVFace6Barcode is not declared." That is expected: these functions were removed. It does not mean your build is wrong, and it does not mean a newer function syntax is needed. Use the left-column field reference instead, for example {OptimizationResults.Face6Barcode}.
The same applies to references that include .Parts. in the path, such as {OptimizationResults.Parts.Face6Barcode}. Face 5 and Face 6 filenames and barcodes are read directly from the OptimizationResults table; the Parts segment is not part of the current reference.
Sometimes, images were referenced to OptimizationResults.Parts.WMFStream and conditions were set to control the rotation of the image. Those rotations are no longer needed.
Formulas
Next, verify that your filenames, barcodes, edgebanding, hbore, and image formulas are referencing the correct table data. If they need to be updated, replace the entry with the updated formula above. For example, replace {MVEdgeBandLeftRotated(...)} with {OptimizationResults.EBLeftRotated}.
Image Condition
Check the Properties | Conditions of all images and remove all conditions. If there are multiple images that were used to handle multiple rotations, remove all but one of those images.
Databand Events
Finally, and only when using Face6 images or filenames, check the Properties | Events of all databands. Assuming that the Name of the Face6 image is Image2, make the following changes to the Before Print Event:
IF OptimizationResults.Face6Barcode<>"" THEN
Image2.Enabled=True
ELSE
Image2.Enabled=False
END IF
For assistance making modifications to your labels, contact your account manager.
Download the MicrovellumFactory.sdf database file attached to this article for newly updated default Labels and Reports. Import using Database Management.
