This tutorial will demonstrate how to add a waste factor to the default edgeband report.

Some companies prefer to add a waste percentage to the total displayed on the edgeband report after it has been printed. Others prefer that the report calculate and display a fixed waste amount before printing.

Also, we understand that each company potentially has differing requirements for the waste amount. Some prefer a given amount, while others prefer a percentage. This tutorial shows you how to add 1 inch (or 25.4 mm), plus 5% to the edgeband piece for each part side. You may adjust this amount in the report as needed by your company.

These step-by-step instructions apply only to the default Microvellum Edgeband Report, but may be applied in principle to other reports.

1. Open the Report Viewer and create a new report based on an existing report.
   
1. Select Toolbox Setup > Design Reports > Design Manufacturing Report > New Report from Existing. 
   
2. Select the Microvellum default Edgeband Report and give it a different name. Select the database tables to include in the report dataset. Usually, you will be able to stay with the existing tables. Click the Microvellum Work Order option, and then click OK.
   
3. Select Designer…
   
4. Add two text components or copy the two highlighted to the location shown in Figure 1.
   


Fig. 01



5. Set the “Top” property of both the copied text components to zero (0).
   


Fig. 02



6. Copy the following expression into the text component in the Header1 databand, or modify as needed:
   

Trim 1 in. + 5%



Fig. 03



7. Copy the following expression into the text component in the GroupHeaderBand1 databand, or modify as needed:
   

{IIF(MVGetUnitType() = "imperial", MVLinealUnitsDisplay(Sum(Edgebanding.Quantity + 1) * 1.05), MVLinealUnitsDisplay(Sum(Edgebanding.Quantity + 25.4) * 1.05))}



Fig. 04



8. Adjust the expression in step 7 as needed to return your preferred waste factor. Figure 5 shows code that adds 1-inch plus 5% to each edgebanding strip. Figure 6 shows code that adds 25.4mm plus 5% to each edgebanding strip. You may modify the values highlighted in yellow and green as needed to add the desired waste in imperial measurement.
   


Fig. 05 - Imperial





Fig. 06 - Metric



9. Click the Preview tab and make sure there are no errors. If there are errors, the following message will be displayed in the report preview screen for a few seconds. Click on the message for more information.
   

Resolve any errors before saving the report!



Fig. 07



10. Test the report with your data before putting the report into production. 
    


Fig. 08