Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | OpenPlant | PlantWise
AutoPLANT | OpenPlant | PlantWise Wiki To Trim Piping BOM Reports Template Fields in OpenPlant Modeler
    • Sign in
    • -AutoPLANT | Bentley Raceway and Cable Management | OpenPlant | PlantWise 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
        • +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
          • Error "No default report template is defined for this report" Appears While Report Generation
          • How to Add/Remove HVAC Component Classes in Grid Report
          • How To Cascade Pipeline Properties to Bolt Report in OpenPlant Modeler
          • How to create Cable Tray Material GRID Report
          • How to Exclude Existing Components from OpenPlant Modeler Reports
          • How to Export Grid Reports in OpenPlant Modeler
          • How to Extract Reports for Multiple Component Class in OpenPlant Modeler
          • How to Generate Consolidated BOM for Components using Pivot Table
          • How to Include Equipment Origin in DGN reports
          • How to Include XYZ Coordinates in Reports for Piping Components
          • How to Insert Report into Drawing in OpenPlant Modeler
          • +How to Show Branch Diameter In Piping Reports
          • How to Show Nozzle Elevation in Report
          • OpenPlant Reporting [FAQ]
          • To Add Pipe Allowances as Field Fit Length in Grid Report
          • To Create BOM for Single Pipeline Using Query Option in OpenPlant Modeler
          • To Generate Weld Quantity for Slip On Joints in Weld Reports
          • To Obtain Bend Angle For Pipe Bends/Mitered Bends in reports, Query by Piping Components
          • To Save BOM Template for Multiple Query in OpenPlant Reporting
          • To Show EC_CLASS_NAME Property for Supports in OpenPlant Modeler Reports
          • To Trim Piping BOM Reports Template Fields in OpenPlant Modeler
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
      • +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
    • How to Associate the Specification Based on Service in OpenPlant Modeler Connect

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

    To Trim Piping BOM Reports Template Fields in OpenPlant Modeler

    Applies To 
    Product(s): OpenPlant Reporting
    Version(s): 08.11.09.564 (SS5) | 08.11.11.87 (SS6)
    Environment:  Windows 7/8.1/10 (64 bit)
    Area:  Reports
    Subarea:  Piping Component
    Original Author: Rahul Kumar, Bentley Product Advantage Group

    Overview

    In OpenPlant Modeler, to Customize BOM reports template as per requirement by user.

    Problem Description

    User requirement was cut short several unnecessary field in BOM template.



    Using Sort column option will not getting saved for particular template when user tries to open reports for the next mode of operation. Thus, resulting to extra time for trimming the fields again and again. Below exercise will aid user to customize the fields and save it for next event. 

    Steps to Resolve

    1. Launch OpenPlant Modeler, Select Project unit. Say Metric here.

    2. Go to OpenPlant Modeler>Tools>Item Reports.



    3. From Piping>Piping Component, select BOM type BOM by Line Number. 

    4. Right click on it, Select ‘Edit’. 



    5. Click on browse option for Querying. 



    6. From Query Dialog, Select “Multiple Types of Items”, say Piping Component & Reducing Piping Tee. 





    7. Click on Property icon, to check list of common properties for selected class.



    8. Click on Clear All option first. Select desired field to show it in Grid Report. 



    9. Once selected the list, click on “Save” to create a template in xml file to refer it next time while generating reports. 



    10. (Optional) again click on Query to check if include sub items button remain unselected. See image below. This should remain selected. 



    11. Click on ok and generate Report. Verify Results.



    12. Also for multiple selections few desired properties will not show under this common properties list. In that case user need to copy those properties to other class as well, in schema through class editor. Click here>>> for more infromation. 

    See Also

    http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/4352.openplant-reporting

    Comments or Corrections?

    Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!

    • DGN Reports
    • OPM
    • NOMINAL_DIAMETER_REDUCING_END
    • template
    • PIPING_COMPONENT
    • Reducing Pipe Tee
    • OpenPlant Modeler Reports
    • NOMINAL_DIAMETER_BRANCH
    • Trim
    • OpenPlant Reporting
    • Fields
    • Share
    • History
    • More
    • Cancel
    • Rahul Kumar Created by Bentley Colleague Rahul Kumar
    • When: Mon, Oct 12 2015 3:51 AM
    • Rahul Kumar Last revision by Bentley Colleague Rahul Kumar
    • When: Tue, Aug 23 2016 2:39 AM
    • Revisions: 3
    • Comments: 2
    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

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