Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | AXSYS | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | AXSYS | OpenPlant | PlantWise
AutoPLANT | AXSYS | OpenPlant | PlantWise Wiki How Do I Use Crystal Reports To Add Fields To My Report [TN]
    • Sign in
    • -Plant Design and Engineering - Wiki
      • OpenPlant Product Compatibility
      • +CONNECT Services - OpenPlant
      • +OpenPlant Modeler CONNECT
      • +OpenPlant PID CONNECT
      • +OpenPlant Isometrics Manager CONNECT
      • +OpenPlant Orthographics Manager CONNECT
      • +OpenPlant Support Engineering CONNECT
      • +OpenPlant Project Administrator CONNECT
      • +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
      • -Bentley AutoPLANT
        • AutoPLANT Product Group Compatibility
        • +AutoPLANT Modeler
        • -AutoPLANT Piping
          • Advanced Routing in AutoPLANT Modeler
          • +AutoCAD - AutoPLANT Piping
          • +Component - AutoPLANT Piping
          • +Database - AutoPLANT Piping
          • +General - AutoPLANT Piping
          • How to Place Sloping Piping in AutoPLANT Modeler
          • +Open/Save - AutoPLANT Piping
          • +Processing - AutoPLANT Piping
          • -Reports - AutoPlant Piping
            • Exporting AutoPLANT reports to Excel or other file formats
            • How Do I Use Crystal Reports To Add Fields To My Report [TN]
            • How to Create a Welds only Report in AutoPLANT?
            • How To Direct The BOM To Sort Welds By Type [TN]
            • Missing component description in Reports
            • Using AutoPLANT temporary Database to create reports
          • +Settings/Attributes - AutoPlant Piping
          • +Tools - AutoPlant Piping
        • +AutoPLANT Equipment
        • +AutoPLANT I&W
        • +AutoPLANT P&ID
        • +AutoPLANT Isometrics
        • +AutoPLANT AutoISOGEN
        • +Bentley Data Manager
        • +Vision/Document Manager
        • +Drawing Flattener
        • +DataSheets
        • +Specification Generator
        • +ProjectWise Integration
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
    • i-model Composition Service for S3D

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

    How Do I Use Crystal Reports To Add Fields To My Report [TN]

       
      Applies To 
       
      Product(s): AutoPLANT Piping
      Version(s): V8i Edition
      Environment:  N/A
      Area:  N/A
      Subarea:  N/A
      Original Author: Derek Cornell, Bentley Technical Support Group
       

    Overview

    This is a technote to show how to add/manipulate fields in the AutoPLANT Piping Bill of Materials. Crystal Reports* is required in order to do this.

    *owned by Seagate Software

    Add the fields to the report in Project Administrator

    1. Open Project Administrator.
    2. Select the desired project.
    3. Expand the project name and expand the report field and select setup.
    4. Move the desired fields from the Available Columns to the Selected Columns area. In this case, we're going to use MAT_GRADE which is not available by default.
    5. Save and close Project Administrator.



      Note: If you have custom fields that you want to use, they must be directly added to the database table PIPING as well as the file ..\Program Files\Bentley\Plant V8i\Reports\Reports.mdb.

    Adding fields to the actual RPT file

    1. Open the desired RPT file you want to customize in Crystal Reports.

      Hint: If you're not sure what file to modify, open AutoPLANT Piping and go to the menu: Piping > Reports > Bill of Materials.... As shown in the screen capture below, which ever report you select from the pulldown menu will display the path to and name of the RPT file it is using.

    2. Once in Crystal Reports, go to the menu: Database > Verify Database...
    3. If the path to the REPORT.MDB is incorrect, update it to C:\Program Files\Bentley\Plant V8i\Reports\REPORT.MDB.
    4. Next, you must modify the Report header. Add the field(s) you are going to want. Here is an example of how it should look with MAT_GRADE added:

    5. Then go down to the section Group Header #6 and stretch it down.
    6. Go to Insert > Text Object...
    7. Place the text object below the last field but above the [-5]. In this case, I'll make it [Mat_Grade=].

    8. Then go to the menu: View > Field Explorer.
    9. In the "Field Explorer" selection tree, pull in the new database field and drop it to the right of the text object inserted in step 6.

    10. Save and close.
    11. Start AutoPLANT Piping.
    12. Go to the menu: Piping > Reports > Bill of Materials...
    13. In this dialog, select the "Options" button.

    14. Then go to the Columns tab and select "Organize". MAT_GRADE is now an available field. Add it to the right side.

    15. Provided that the MAT_GRADE field is populated with data for each component (and you can use Edit Component to check), the values will now show in your Bill of Materials.

    See Also

    Product TechNotes and FAQs

    Understanding_Component_Preferences_In_AutoPLANT

    External Links

    Bentley Technical Support KnowledgeBase

    Bentley LEARN Server

    Comments or Corrections?

    Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to the "Comments" area below. THANK YOU!

     

     

    • piping
    • Bill of Materials
    • Material List
    • reports
    • AutoPLANT
    • BOM
    • TechNote
    • add
    • modify
    • AutoPLANT Piping
    • crystal reports
    • Insert
    • Report
    • Fields
    • Share
    • History
    • More
    • Cancel
    • Phil Chouinard Created by Phil Chouinard
    • When: Tue, Sep 14 2010 3:27 PM
    • Artiom J Last revision by Artiom J
    • When: Mon, Sep 7 2015 11:06 AM
    • Revisions: 5
    • Comments: 0
    Anonymous
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • User Management
    • Licensing Manager
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

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