How to Change Set of Bolts into Total Quantity of Bolts in BOM by Line Number Reports in OPM throug



Applies To 
Product(s):OpenPlant Project Administator CONNECT Edition
Version(s):

(10.08.00.51) Update 8

Environment: Windows 10 (64-bit)
Area: Customization
Subarea: Reports
Original Author:Ashutosh Patil, Bentley Product Advantage Group

Background

In OPM CE, Whenever user extract report BOM By Line Number the quantity of Bolt is displayed into Set of Bolts instead of Totally Quantity of Bolts e.g For 4x8 Qty its 4 No of Flanges which has  each 8 set of bolts.



This Wiki will help user to make the changes in Scripting part for BOM by Line Number in Reporting Designer through OPPA and it can be verified in OPM CE reports.

Steps to Accomplish

  1. Since the Report need to be fetched from OPM CE, So kindly go to OPPA CE.



  2. Select the required Workspace→Workset →Select application OPPID CE →Reporting Designer.Below Considered Metric Workset.



  3. Window with Edit Report get launched, In it Select BOM By Line Number and then Click on Script as shown in image below.
     


  4. To make the changes scroll to line number  between 87-100 as shown below



  5. As shown in image below edit to Line 95 and add below lines, 

    int x= setCount*Int32.Parse(numberOfBolts);
    results = string.Format("{0}", x);



    After making the changes in script hit on save.

  6. Go back to OPM CE and hit on Refresh and then generate  report through BOM By Line Number the Set of bolts would be converted into Totally quantity.

See Also

communities.bentley.com/.../fundamentals-of-reporting-designer-2-report-selector-and-tools-box

Still a Problem?

If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround