Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki How to Sort Quantified BOM Report Template in Open Utilities Substation
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • -OpenUtilities Substation
      • -CONNECT Edition - OpenUtilities Substation
        • +3D Layout Features - OpenUtilities-Substation
        • +Administration Features - OpenUtilities Substation
        • +Automation Feature
        • +Component management - OpenUtilities Substation CONNECT
        • +Components Features - Substation CONNECT
        • +Construction Drawing - Openutilities Substation CONNECT
        • +Database Platform Support - OpenUtilities Substation
        • +Drawing Managment - OpenUtilities Substation
        • +Installation_Configuration - Bentley Substation CONNECT Edition
        • +Maintenance Feature - Open Utilities Substation CONNECT
        • +Migration - OpenUtilities Substation CONNECT
        • +OS & Hardware Support - OpenUtilities Substation CONNECT
        • +Panel Layout- Substation CONNECT
        • +Power Platform Support - Substation CONNECT
        • +Print and Plot feature
        • +Print and Publish feature
        • +Project Management - OpenUtilities Substation CE
        • +ProjectWise Integration - OpenUtilities Substation CONNECT
        • +Replace Device ID - Find_Replace - OpenUtilities Substation
        • -Reports_Output Features - OpenUtilities Substation CONNECT
          • -Reporting - Reports_Outputs Features - OpenUtilities Substation
            • Filter a Cable Report in OpenUtilities Substation CONNECT
            • How to Display current date and time on reports in OpenUtilities Substation CONNECT
            • How to Place Report on Drawing using Text On Drawing in OpenUtilities Substation
            • How to Sort Quantified BOM Report Template in Open Utilities Substation
            • Wiring diagram or cable cross reference not populating in report
        • +Resolved issues in OpenUtilities Substation Releases
        • +Wire Numbering - Substation CONNECT
        • +Wiring Feature - OpenUtilities Substation
      • +3D Layout Features - Bentley Substation
      • About Bentley Substation
      • +Administration Features - Bentley Substation
      • +Automation Features - Bentley Substation
      • +Component Management - Bentley Substation
      • +Construction Drawings - Bentley Substation
      • +Database Platform Support - Bentley Substation
      • +Grounding Grid - Bentley Substation
      • How to log Service Request
      • +Installation_Configuration - Bentley Substation
      • +Interoperability - Bentley Substation
      • +PowerPlatform Support - Bentley Substation
      • +Project Management - Bentley Substation
      • +ProjectWise Integration - Bentley Substation
      • Working from home with OpenUtilities Substation
    • Promis.e Paths
    • +Promis.e Wiki
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    How to Sort Quantified BOM Report Template in Open Utilities Substation

      Product(s): OpenUtilities Substation
      Version(s): CONNECT
      Environment: N/A
      Area: Template Management
      Subarea: Report Template Designer


    Issue with Sorting BOM Quantified Reports

    It can be observed that all of the OOTB BOM Quantified Reports are sorted in Part Number. It can also that when custom sorting is applied to the Report to sort on the Manufacturer or Device Tag  instead of Part Number the sorting does not work. 


    Background

    This issue is occurring because the BOM Quantified reports are Grouped on Group Header field. The Sorting on the Run Report dialog only works for the Detail Group. Hence due to this reason the Sorting for the BOM Quantified reports should be added via Report Template designed. 

    This document describes how to modify a "Bill of Materials (Quantified)" report template so that it sorts by the desired fields.

    Steps to Accomplish

    Refer to the animation below when following this procedure.

    1. Open a page in a project that makes a good test for the desired sorting.

    2. Open Report Template Designer from Output >> Report Template Designed.

    3. Select File > Open and open the report template to be modified or used as the basis for a new template, such as "BOM_Qty - Letter".



    4. In Designer view Click the Group Header  and select ">" arrow that then appears on the band.  Group Header Tasks dialog will pop up, click the [...] button next to the "GroupFields" field




    5. On the resulting GroupField Collection Editor dialog, click the Add button.  An additional GroupField item should appear in the left pane.

    6. With the new GroupField item highlighted, select the field to sort by in the FieldName field in the right pane. For example, "Manufacturer".




    7. Remove the Data Fields. from the Field Name and then move the new Field to higher priority using Up/down arrow button. 

    8. Use the up and down arrow buttons or arrange the GroupField items in the desired order.  For example, to sort by Manufacturer and then partnumber, the GroupField item for "Manufacturer should appear above the GroupField item for partnumber in the left pane.

    9. Click OK to close the GroupField Collection Editor dialog.

    10. Preview the report by selecting the Preview tab.

    11. If the results are acceptable, use File > Save to save the template or File > Save As to save it as a new template.

    12. Close the Report Template Designer.

    If different sorting is required for different clients or different types of projects, use "Save As" to save the template to different names with different sorting applied.

      Original Author: Avanti.k
    • sorting
    • BOM
    • Reports_Output Features
    • BOM Quantified
    • how to
    • en
    • OpenUtilities Substation
    • Share
    • History
    • More
    • Cancel
    • Avanti Khandalkar Created by Avanti Khandalkar
    • When: Wed, Jun 23 2021 5:11 AM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Tue, Jun 28 2022 2:03 PM
    • Revisions: 3
    • 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