Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki How to Change Set of Bolts into Total Quantity of Bolts in BOM by Line Number Reports in OPM through Reporting Designer in OPPA CE
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • -OpenPlant Project Administrator CONNECT
          • Copy Joint Map from OPPA CE U10
          • Difference between Setup, Upgrade and iModel Link in OpenPlant Project Administrator CONNECT Update 9.
          • +Errors, Logs, Messages, Crashes in CONNECT - OpenPlant Project Administrator
          • Fundamentals of Reporting Designer 2: Report Selector and Tools Box
          • Fundamentals of Reporting Designer 3: Field List and Report Explorer
          • Fundamentals of Reporting Designer Using OpenPlant Project Administrator CONNECT Edition
          • How to Change Set of Bolts into Total Quantity of Bolts in BOM by Line Number Reports in OPM through Reporting Designer in OPPA CE
          • How to add a derived class using OpenPlant Project Administrator
          • How to add a Network Drive WorkSpace to OPPA CE & Activate it for OPM CE
          • How to add a property using OpenPlant Project Administrator
          • How to Add COUNT in Reports via Reporting Designer
          • How to Add custom attribute on a double type property in OpenPlant PID CONNECT Edition
          • How to Add Filter to Existing Report Template in Reporting Designer
          • How to Add Groups via Reporting Designer and its Significance
          • How to Add Some Spec Properties for the Existing Component in OpenPlant Modeler Connect
          • How to Add SR NO in Reports via Reporting Designer
          • How to Add the Plant Area Property Name in Tag Name For Equipment
          • How to add Various Grades of Material to Lookup Table.
          • How to Add Weight & Sum of Weight of Piping Component in Reports.
          • How to Associate WorkSet from a Custom WorkSpace to a CONNECT Project
          • How to Change Sequence of Unit, Plant, Service in OpenPlant Project Administrator CE
          • How to Change the Unit for Main Size in a Mixed Metric Environment
          • How to Collaborate WorkSet with ProjectWise using OpenPlant Project Administrator
          • How to Connect with Bentley Technical Support Team using TeamViewer
          • How to convert Cable Tray Specification to a Catalog in OpenPlant Specification Generator.
          • How to Convert Spec to different Unit via SpecGen.
          • How To Create Catalog From Given Excel File Using OpenPlant Specification Generator
          • How to Create Configuration via ProjectWise Share for OpenPlant Modeler CONNECT Edition Update 7
          • How to Create New Associated Item using OpenPlant Project Administrator Update 10
          • How to Create New Spec Using OpenPlant Specification Generator CONNECT Edition.
          • How To Create Specs From Converted Catalog of AutoPlant to OpenPlant Catalog using Specification Generator
          • How to Create WorkSpace & WorkSet in OpenPlant Project Administrator CONNECT Edition
          • How To Enable Other Openplant Applications For Project in OPPA CONNECT Edition
          • How to Generate specification report to other file format.
          • How to Get Customized Bend Point Radius Data in OpenPlant Modeler Connect
          • How to get Iso Sheet Name in Piping MTO via Reporting Designer
          • How to get TOTAL in Reports via Reporting Designer
          • How to Import Existing Custom Report Template from One Project to Another via Reporting Designer
          • How to Include End Condition in OOTB Elbow Reports through Reporting Designer in OpenPlant Modeler Connect Edition
          • How to Include End Condition in OOTB Flange Reports through Reporting Designer in OpenPlant Modeler Connect Edition
          • How to Include Nominal diameter Branch in OOTB Weldolet through Reporting Designer in OpenPlant Modeler Connect Edition
          • How to install OpenPlant Project Administrator with Class Editor and Specification Generator
          • How To Install or Enable Specification Generator Using OpenPlant Project Administrator CE
          • How to make fields editable/ read only in OpenPlant Project Administrator Connect Edition.
          • How to Modify Piping Report in OpenPlant CONNECT Edition to Display Pipe Quantity in Meters Instead of Millimeters
          • How to Modify Tags Using IIF Expression in OpenPlant Project Administrator.
          • How to Modify Value Map Using OpenPlant Project Administrator
          • How to Move a Property from One Category to Other
          • How to move property to another category in OpenPlant Project Administrator Connect Edition.
          • How to Open Schema & Supplement it with desired Schema in Bentley Class Editor CONNECT Edition.
          • How To Perform Exchange Operation in OpenPlant Specification Generator
          • How to Provision Schemas to CONNECT Project using OpenPlant Project Administrator
          • How to Reroute Workset Level Folders to Workspace Level
          • How to Upgrade OpenPlant Modeler V8i WorkSpace to OpenPlant Modeler CONNECT Edition
          • How to Upgrade Schema From OpenPlant CONNECT Update 4 to Update 5 Version
          • How to use AutoPlant Catalogs to create OpenPlant Spec using OpenPlant Specification Generator.
          • How to Use LOADINSTANCES Input Method for Standard Preference in OpenPlant Modeler CONNECT Edition
          • How To Use Merge Option To Combine Two Catalogs using Specification Generator
          • How to Use Spec Default Feature in OpenPlant Modeler CONNECT Edition
          • To Create Custom Support MTO Report Using Reporting Designer Tool
          • [FAQ] - OpenPlant Project Administrator CONNECT Edition
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • +OpenPlant Modeler v8i
        • +OpenPlant Isometrics Manager v8i
        • +OpenPlant Project Administrator v8i
        • +OpenPlant PID v8i
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
        • How to get list of installed applications/programs on Windows Machine using Command Prompt.
        • How to get list of Windows Updates installed on the machine using Command Prompt.
        • How to Package WorkSpace to be Shareable to Users for OpenPlant Projects
        • How to find iModel.dgn file of another domain in PlantSight
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
      • Your Feedback is important to us!

     
     Questions about this article, topic, or product? Click here. 

    How to Change Set of Bolts into Total Quantity of Bolts in BOM by Line Number Reports in OPM through Reporting Designer in OPPA CE


    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

    Fundamentals of Reporting Designer 2: Report Selector and Tools Box
    Applies To OpenPlant CONNECT Edition Product(s): OpenPlant Project Administrator Version(s): CONNECT Edition (10.07.00.32) Environment: Windows 8.1/10 (64 bit) Area: Reporting…
    Last edited over 2 years ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki

    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

    • bolts
    • OpenPlant Modeler
    • set of bolts
    • OPPA CE
    • total quantity of bolts
    • Bolt
    • number of bolt
    • OPM CE U8
    • Share
    • History
    • More
    • Cancel
    • Ashutosh Patil Created by Bentley Colleague Ashutosh Patil
    • When: Mon, Apr 19 2021 6:09 AM
    • Revisions: 1
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies