Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki How to add the User Defined Attributes into Reports
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • +OpenPlant
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • -Bentley Raceway and Cable Management
        • How to Download Bentley Raceway and Cable Management
        • Bentley Raceway and Cable Management Product Compatibility
        • -CONNECT Edition - Bentley Raceway and Cable Management
          • +Resolved issues in Bentley Raceway and Cable Management Releases
          • +What's New in Bentley Raceway and Cable Management Releases
          • +Manufacturer Based Raceway Content in Bentley Raceway and Cable Management
          • +AutoPlace Conduit tool - BRCM CONNECT Edition
          • +Cable Reports- Cable Pull Cards and Cable Drums-Bentley Raceway and Cable Management CONNECT Edition
          • +Cable Routing-Bentley Raceway and Cable Management CONNECT Edition.
          • +Drawing generation - Bentley Raceway and Cable Management CONNECT Edition
          • +i-Model - Bentley Raceway and Cable Management CONNECT Edition
          • +Installation_Configuration - BRCM CONNECT
          • +Power Platform Support - BRCM CONNECT Edition
          • +Project Setup- Bentley Raceway and Cable Management
          • +ProjectWise Integration - Bentley Raceway and Cable Management CONNECT
          • +Raceway Design Tools - Bentley Raceway & Cable Management
          • +Raceway IDs - Bentley Raceway and Cable Management CONNECT
          • -Reports - Output Manager - BRCM CONNECT Edition
            • Functions and Operators list for Report Designer in Bentley Raceway and Cable Management
            • How to add Calculated Field in Reports
            • How to Add Equipment UDAs in BOQ Reports
            • How to add the User Defined Attributes into Reports
            • How to apply filters to the Columns of the Output Reports
            • How to Configure Equipment Product Codes
            • How to Export Custom Cable UDAs in Cable Route List report
            • How to generate Isometric Cable Report.
            • How to Include Raceway Accessories in the BOQ Report
            • How to Insert Page Break in BRCM report templates
            • How to Perform Calculations on Product Code (PCode) values
            • How to Utilize Equipment UDAs in BOQ report for Product codes and Descriptions
          • +Underground System - Bentley Raceway and Cable Management CONNECT Edition
          • +User Defined Attributes (UDA) Settings - Bentley Raceway and Cable Management CONNECT Edition
          • +Components Center - Bentley Raceway and Cable Management CONNECT Edition
          • +i-Twin Services-Bentley Raceway and Cable Management CONNECT Edition.
          • +Equipment & Cable List Import-Bentley Raceway and Cable Management CONNECT.
          • +Interoperability
        • +V8i - 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 add the User Defined Attributes into Reports

    Product(s): Bentley Raceway & Cable Management
    Version(s): CONNECT Edition 
    Environment: N/A
    Area: Output Manager
    Subarea: UDAs in Report
    Orignal Author: Vikrant Kale

    Background

    User-defined attributes(UDA) are additional information about an element in the project that can provide more details about the design elements which is helpful in design analysis. UDAs can be very useful information to add to reports.

    If you want to include UDA into reports, then it is possible using the Bentley Raceway and Cable Management Output Manager tool. The ability to add a UDA in the Reports can be a highly useful thing.

    This article will guide you to add UDA into reports.

    Steps to Accomplish

    1. Please have a look at these articles for more details about adding the UDAs.
      1. How to Create a Cable UDA in Bentley Raceway and Cable Management CONNECT Edition.
      2. How to Create Equipment UDA in Bentley Raceway and Cable Management CONNECT Edition.
      3. How to Create Raceway UDA in Bentley Raceway and Cable Management CONNECT Edition.
    2. Navigate to the standard dataset and open the DB_DataDictionary.xml file from the metadata folder.



    3. This file lists the database tables. For adding the UDAs to the reports you need to edit the EXT
      The table names are defined in the XML file as follows:



    4. See the following examples to add the UDAs to report tables.

      In this example, we are adding a Cable UDA named ‘AssetNumber’. Following are the settings:
      name: In this field provide the ID of the UDA but it should be in the CAPITAL letter
      format: Data format of the UDA value.
      len: Character length of the UDA value
      repfieldclass: Class of this field, defined as a macro
      repfieldparl1: Field parameter value to be set as ($0,UDA ID)
      repfieldpar2: The value of this parameter is set as ‘cable’ as we are adding cable UDA.

      For the Cable Schedule report: table EXT_CABLES



      For the Cable route report: Table EXT_CABLEROUTE



      Also if you want to add the UDA to BOQ reports you can add it using the following tables.
      For the BOQ report: Table EXT_BOQENVELOP



      For the BOQ raceway report: Table EXT_BOQRW



    5. In the article ‘How to import Cable UDA using Cable list import tool’ you ware able to import the Cable UDA. Here we have added the same UDA (AssetNumber) to the above report's tables. Now we will add the same UDA in the Cable report.
      Launch the application and open the DGN file. Navigate to the Output ribbon tab and click on Output Manager.
      Select the desired Cable report and click on Select Resources.



    6. Collaboration Manager will open.
      Select the required resources for the reports and click OK.

    1. In the Output Manager dialog select the report and click on the Edit Report Templet at the top.



    2. Report Designer will open. Navigate to field list and in the ReportInformation tab, you can see the added cable UDA.
      Drag and drop the UDA to the report templet ‘Details’



    3. You can save this report templet as follows:



    4. Back to Output Manager, select the report and click



    5. Review the report.

    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!

    • Report Customization
    • BRCM CONNECT Edition
    • UDA
    • Reports - Output Manager
    • bentley raceway and cable management
    • User Defined Attributes
    • Share
    • History
    • More
    • Cancel
    • Vikrant Kale Created by Bentley Colleague Vikrant Kale
    • When: Thu, Jun 18 2020 11:14 AM
    • Vikrant Kale Last revision by Bentley Colleague Vikrant Kale
    • When: Thu, Jun 18 2020 11:18 AM
    • Revisions: 2
    • 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