Original Question: BRCM - Vertical Bend Product Code

Vertical bends show degrees in 90 and -90 which distinguishes between inside and outside, but the Product Code for both is the same (Inside).

Background

Currently the software does not distinguish inside and outside bends as different part types. It is possible to work around this by adding a script to the report template to replace "VI" with "VO" if the bend is negative (if the description contains "Vertical Bend -").

The following process may need to be adapted to fit particular cases. Manufacturers may use different codes to indicate whether a bend is inside or outside.

Steps To Accomplish

1. Open Output Manager.
2. Select an appropriate template such as Detail_BOQ in the tree on the left, lock resources.
3. Click the Edit Template button along the top of Output Manager.
4. In the Report Designer, select File > Save As and save the template with a new name.
5. In the Designer view, click the cell that contains [PCODE]. This will reveal a small > button above the cell.  Click this button.
6. On the resulting Table Cell Tasks dialog, set the Data Binding field to "None".
7. The cell selected in step 5 should now have no text in it. Right-click this cell and select Properties.
8. In the resulting Property Grid, expand Scripts.
9. Click into the Before Print row then click the down arrow that appears. Select "(New)".
10. This creates a new, empty function that looks something like the following:
    

    private void tableCell13_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) {

11. Paste the following between the { } brackets:
    
    string d = "", p = "";
    if (GetCurrentColumnValue("DESCR") != DBNull.Value)
     d = (string)GetCurrentColumnValue("DESCR");
    if (GetCurrentColumnValue("PCODE") != DBNull.Value)
     p = (string)GetCurrentColumnValue("PCODE");
    if (d.Contains("Vertical Bend -"))
     p = p.Replace("VI", "VO");
    (sender as XRLabel).Text = p;
    
    
12. Select the Preview tab to preview the report.
13. Save and close Report Designer.

Keywords: BRCM, TFS 152819