BRCM - Vertical Bend Product Code

Currently the software does not distinguish inside and outside bends as different part types. This is a known issue, TFS 152819.  If you're interested, it is possible to work around the issue 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.

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.