Background

Total quantities of parts in a project may not always be whole numbers.  As designed, the project may contain 3.435 lengths of DIN rail or 1.2 boxes of fuses.  While accurate, the totals may not be ideal for how items are actually purchased.

This article describes how to use scripts to round quantities up to the nearest whole number on quantified bill of materials reports. As an example, the BOM_Qty - Letter template is modified.

Steps to Accomplish

1. Open a page in a project that includes some fractional total quantities of part numbers.
2. Open Report Template Designer.
3. Select File > Open and open the BOM_Qty - Letter report template.
4. Select the Designer tab at the bottom of Report Template Designer.
5. Click to select the cell that displays the quantity in the GroupHeader1 band.
6. Click the small > button that appears above the cell.
   
7. Click the [...] button for the Summary field on the resulting pop up.
   
8. On the resulting Summary Editor, set the Summary function field to Custom, keep Summary Running set to Group, click OK. The cell in the Designer view should now read "Custom(...."
9. Select the Scripts tab at the bottom of the Report Template Designer.
10. Paste the following into the Scripts, being careful not to overwrite any existing scripts:
    
    

    double totalQuantity = 0;
    private void Quantity_SummaryReset(object sender, EventArgs e) {
        // Reset the result each time a group is printed.
        totalQuantity = 0;
    }
    
    private void Quantity_SummaryRowChanged(object sender, EventArgs e) {
        // Calculate a summary.
        totalQuantity += Convert.ToDouble(GetCurrentColumnValue("QUANTITY"));
    }
    
    private void Quantity_SummaryGetResult(object sender, SummaryGetResultEventArgs e) {
        // Round the result
        e.Result = Math.Ceiling(totalQuantity);
        e.Handled = true;
    }

    
    
    
11. Select the Designer tab at the bottom of Report Template Designer.
12. Right-click the cell for Quantity in the GroupHeader1 band and select Properties.
13. On the resulting Property Grid view, expand the Scripts row.  The Scripts row is in the Behavior category.
14. Set Summary Get Result to Quantity_SummaryGetResult
    Set Summary Reset to Quantity_SummaryReset
    Set Summary Row Changed to Quantity_SummaryRowChanged
    (these are the names of the functions pasted in step 10)
    
15. Preview the report by clicking the Preview tab.
16. If the results are acceptable, use File > Save to save the template or File > Save As to save it as a new template.
17. Close the Report Template Designer.

See Also

Before Print scripts for report templates

External Links

DevExpress: How to: Calculate a Custom Summary