Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki Fundamentals of Reporting Designer Using OpenPlant Project Administrator CONNECT Edition
    • 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
          • To Resolve Class Editor Graphic Elements are too Small
          • [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. 

    Fundamentals of Reporting Designer Using OpenPlant Project Administrator CONNECT Edition

    Applies To 
    Product(s): OpenPlant Modeler
    Version(s):

    10.07.00.32+

    Environment:  Windows 8 (64-bit) | Windows 10
    Area:  OpenPlant Project Administrator
    Subarea:  Reporting Designer
    Original Author: Deepak Singh, Bentley Product advantage Group


    Overview

    In OpenPlant Project Administrator CONNECT Edition, new Reporting Designer has been introduced that is completely different from V8i reporting tool.

    Background

    In this wiki article, we will understand about the concept of new report designer that has been introduced for OpenPlant CONNECT suits. The new report designer is based on DevExpress technology. In this wiki article, we will outline the very basics/fundamentals for creation of reports using OpenPlant Project Administrator CONNECT Edition. We will discuss on below mentioned topics.

    • How to create a new report & what are the possible ways to create a new report.
    • Page Header & Page Footer
    • Report Header & Report Footer
    • Group Header & Group Footer
    • Detail Band
    • Adding data to Detail Band

    A. How to create a new report & what are the possible ways to create a new report.

    1. Launch OpenPlant Project Administrator CONNECT Edition.
    2. Select your desired workspace/workset. Pick the suitable application here OpenPlant Modeler, switch to Tools & select Reporting Designer to launch.



    3. Once Reporting Designer is loaded we can see the interface of Reporting Designer.
    4. From left hand, pane under Report Selector we can see the pre-defined template folders as shown below.



    5. Each report folder contains respective report based on disciplines.
    6. Right click on any report to create a New Folder as shown below.



    7. Report creation can be done via two means (Report Via Wizard & Report via File)

    New Report via Wizard

    1. Click on New Report > New Report via Wizard.
    2. Enter the desired name & display for report.



    3. Notice that EC Query is showing in red color, this shows that no EC Classes has been selected for this report.
    4. Click on Design to define EC Query for your report.
    5. Search for desired class name, here Piping Component (OpenPlant_3D).
    6. Once selected, click on OK.



      Note: Selected EC Query can be saved as well to be used in future while creating different report.

    7. Notice that under Create Report dialog, we can see the selected Class Name.
    8. Click on OK to proceed further.



    9. Under Report Wizard, select desired report type (here Empty) & click on Finish.



    10. Once completed, created report can be seen under report selector as shown below.
    11. Also, any report can be saved to file for future use in creating report, refer image below.


      New Report via File

      A new report can be created via report file as well. In above section we have noticed that how report can be saved. We can use any saved report to create a report via File.

    1. Click on New Report > Report via File.



    2. This will ask to point to saved report file (*.repx file). Select any saved report file & click on Open.



    3. This will ask to define the report name, define EC Query for this report, refer image below.
    4. Enter desired report name.



    5. For definition of EC Query, we will import existing saved query file (*.ecquery.xml).
    6. Click on Import icon & point to saved ecquery.xml file. Once done click on Open.



    7. Notice that based on import query, classes get loaded & can be seen as shown below.



    8. Click on OK to create report.

    B. Page Header & Page Footer

    1. These bands are at the top and bottom of every page in a report. They display information that should be printed on every page.



    2. Bands can be inserted by right clicking on white-space of report & selected desired band type. Refer below image.


    3. From Tool Box, we can select Labels & drag it Page Header section. In the similar fashion, for Page Footer same can be done as shown below.



    4. If we general report from OpenPlant Modeler, we can see result as shown below.


    C. Report Header & Report Footer

    1. The Report Header is the report's first band (margins are "out-of-page" zones). Use this band to display the report's name, company logo, date of creation, username, etc.The Report Footer is placed before the Page Footer and Bottom Margin on the report's last page. You can use the Report Footer band for report summaries or conclusions.
    2. From Tool Box, we are choose desired options for our report header & report footer. Sample defined Report Header & Report Footer as shown below.



    3. If we generate report, we can see output as shown below.

    D. Group Header & Group Footer

    1. These bands are above and below each group. The Group and Sort Panel create these bands automatically.
    2. From Group and Sort dialog, whenever we Add a Group (here Line Number) then Group Header band will automatically added to report as shown below.



    3. Using Label tool added text (LINE NUMBER) to show the group header. Notice that under Group & Sort dialog, we have option to show/hide group header & footer. Tick option means show & uncheck is hide.
    4. If we generate report we will get result as shown below.

    E. Detail Band

    1. The Detail band is printed for every record in a data source unless you filtered the data. Please note that whenever we create a report by default a detail band be there & it can’t be deleted.


    F. Adding Data to detail band

    1. Addition of fields, data, and field with data binding can be added to detail band to see the details of report. We can add fields from Field List dialog. To add the fields, select the desired field from Field List & drag it to detail band.

      Sample Report with Fields in Detail Band



      If we generate the report out of it for some piping component placed in OpenPlant Modeler, we will see details as shown below.

    See Also

    How to Preview Reports of Placed Components in OpenPlant Modeler
    Applies To Product(s): OpenPlant Modeler Version(s): CONNECT Edition 10.07.00.32 Environment: Windows 8.1/10 (64-bit) Area: OpenPlant Reports Subarea: - …
    Last edited over 1 year ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki

    Comment or Corrections

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

    • External Reports in OpenPlant Modeler
    • Reporting Designer
    • OpenPlant Modeler CONNECT edition
    • Reporting Designer in OpenPlant Project Administraotr
    • External Reporting
    • Report Customization in OpenPlant Modeler
    • OpenPlant Project Administrator Report Customization
    • OpenPlant Reporting
    • Share
    • History
    • More
    • Cancel
    • Deepak Singh Created by Deepak Singh
    • When: Mon, May 18 2020 9:16 AM
    • Deepak Singh Last revision by Deepak Singh
    • When: Mon, May 18 2020 9:30 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