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 How Define to List Property Values in Limited Number of Rows
    • 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 Isometrics Manager for OpenPlant
            • Installation/Upgradation Steps for OpenPlant Isometrics Manager
            • +Errors, Logs, Messages, Crashes - OpenPlant Isometrics Manager
            • +Open/Save - OpenPlant Isometrics Manager
            • +Processing - OpenPlant Isometrics Manager
            • -Settings/Attributes - OpenPlant Isometrics Manager
              • -Configuring the BOM and Reports
                • Grouping of Supports Based on Common EC CLASS Name
                • Grouping of Supports Based on Common Tag Name
                • How Define to List Property Values in Limited Number of Rows
                • How to Accumulate Weight Information
                • How to Add Desired Custom Property Value to OpenPlant Isometrics BOM
                • How to add End type Information in Isometric Bill of Material Cut list
                • How To Add Field components Under Shop Material In Bill Of Materials
                • How to Add Piping Component Properties on Weld Reports
                • How To Create Various BOM Report Types in OpenPlant Isometrics Manager
                • How to Generate Reports based on Size
                • How to Generate Reports based on Size with Sequential Numbering System
                • How To Display only Support List in OpenPlant Isometrics Manager Bill of Materials
                • How to display Pipeline size in Bolt BOM Description in Isometric Manager
                • How to Force Field Weld Component to Appear Under Field Materials in BOM
                • How to Report Cut list in Multiple Columns
                • How to Round Up Quantity in Bill of Material
                • How To Set Reducer Size Annotation in BOM Report
                • How to Show Calculated Pipe Weight in BOM
                • How To Show Tag For Multiple Components in Isometrics BOM
                • How To Show Total Weight for Bill Of Material in OpenPlant Isometrics Manager
                • How To Sort PARTID In OpenPlant Isometrics Manager BOM
                • Modifying the Welding Information
                • To Add End Type Information (BEVEL, SQCUT) in Isometric BOM Cut list
                • To Concatenate Additional Property in RBR-UBR Description in BOM
                • To Display Additional Material Information in Drawing and Reports for OpenPlant Isometrics Manager
                • To Display Bolt Length as Metric in BOM Description
                • To Display New Line for each Attributes in BOM
                • To Display Pipe Bend components in Numbers in OpenPlant Isometrics Manager BOM
                • To Display Sum of Bolt Length and Bolt Excess Length in BOM
                • To Display UNIT information for Support in BOM for OpenPlant Isometrics Manager
                • To Fix BOM column Text Wrapping issue in OpenPlant Isometrics Manager
                • To Get Shop Field Information for welds in OpenPlant Isometrics Manager
                • To include the sheet number in the SPOOLID of BOM in the OpenPlant Isometrics Manager
                • Weld Tags Sorting in Numerical and Sequencing Order in OpenPlant Isometrics Manager
              • +DBQuery : usage, logging, debugging
              • +Grid Lines - OpenPlant Isometrics Manager
              • Connectivity Information Lost in Isometric After Detaching/Attaching Reference Model
              • How To Add Detail Sketches in OpenPlant Isometrics Manager Using OpenPlant Modeler
              • How to Add NEW Schema Field to Component for Custom Tagging in OpenPlant Isometrics Manager
              • How to Adjust Imperial Accuracy in OpenPlant Isometrics Manager
              • How to Assign FieldFit Weld Allowances or Other Weld Types for BOM & Cut List in OpenPlant Isometrics Manager
              • How to Change Numbering Sequences For Spools, Welds & CUTID
              • How to Control Socket Weld Symbols in OpenPlant Isometrics Manager
              • How to Define Existing lines in OpenPlant Isometrics Manager
              • How to Delete Levels and Create Custom Level List in OPIM Seed File
              • How To Display Co-ordinates Using Multipliers
              • How to Display Nozzle Rating and Facing Information on Connection & Continuation in OpenPlant Isometrics Manager
              • How To Display Pipe Length using Multipliers
              • How To Feature Microstation Tags And AutoCAD Attributes
              • How to Format Data in Fractions Listed Under Drawing Tag Data
              • How to Get Exclusive Support PARTID Report with Prefix
              • How to Hide Sizes Of Bolts in Bill Of Material
              • How to Modify Valve Operator Label to Show Description
              • How To Modify Valve Tag
              • How to Obtain Different Descriptions for Trimmed Elbow in OpenPlant Isometrics Manager BOM
              • How to Remove Duplicate Annotation For Reducing Flange from Line Pipe Module
              • How to Remove Information from Isometric Output
              • How to Rotate Support Symbols in OpenPlant Isometrics Manager
              • How to Round Off Values After Decimal For Support Co-ordinates
              • How To Show Existing Lines For Fasteners In OpenPlant Isometrics Manager
              • How to Split the Components on Different Description and to Avail Different PartID in BOM
              • Managing Isometrics Styles
              • +Modifying Dimensions
              • +Modifying Symbols in OpenPlant Isometrics Manager
              • +Modifying Text and Annotation Settings
              • +Modifying the Isometric Content
              • +Setting File Type (DGN or DWG) and Paper Setting
              • To Specify Various Imperial Value Output Type in OpenPlant Isometrics Manager
              • To Concatenate Length Property in Description Field for BOM
              • To Define Symbology for Multiple Component State in OpenPlant Isometrics Manager
              • To Display Handwheel Orientation For GearBox Operator in OpenPlant Isometrics Manager
              • To Display Multiple Rows for Notes as Labels
              • To Display New Property in Description Field For BOM in OpenPlant Isometrics Manager
              • To Display Right Angle Operator Direction with Spindle in OpenPlant Isometrics Manager
              • To Display Support Orientation in OpenPlant Isometrics Manager
              • Additional 3D.DWG file Created in OpenPlant Isometrics Manager
              • How to insert spaces between PARTID labels in OpenPlant Isometrics Manager
          • +OpenPlant Isometrics Manager for AutoPLANT
          • +Release Notes - OpenPlant Isometrics Manager
          • OpenPlant Isometrics Manager [FAQ]
        • +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
      • +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. 

    How Define to List Property Values in Limited Number of Rows

    Applies To 
    Product(s): OpenPlant Isometrics Manager
    Version(s): 08.11.09.XXX (SS5) | 08.11.11.XX (SS6)
    Environment: Windows 7/8.1/10 (64-bit)
    Area: Configuring the BOM and Reports
    Subarea:
    Original Author: Kestutis Mitkus, Bentley Product Advantage Group

    Problem Description

    In OpenPlant Isometrics Manager, user created separate SPOOLID report in Bill of Materials list, but all SPOOLIDs in this report are listed in one column. This report is using to much space and user requirement is to list all these SPOOLID values in one row.



    Steps to Resolve

    In the Style.cfg file (for each isometric style) there is a variable (MAXLINES) which can be added and defined to limit the number of rows for a report.
    So if a report exceeds the maximum number of rows defined, Isometric Manager will add columns to the right using the widths of all of the columns to accommodate the additional records.

    1. Open report.def file from required Isometrics style's config folder.
      For OpenPlant Modeler:
      C:\ProgramData\Bentley\OpenPlantModeler V8i\WorkSpace\Projects\[...]\DataSet\Isometrics\Styles\[...]\Config

      For AutoPLANT Modeler:
      C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\[...]\Config\OpenPlant\Isometrics\styles\[...]\config

    2. Created one new report for SPOOLID header.
      #-----------------------------------------------------------------------------
      # SPOOLID Header
      #-----------------------------------------------------------------------------
      REPORT = SPLH
          TEXT = -------------------------SPOOLS---------------------------------
          Write =
          NODE = 70

    3. Create one new report for SPOOLID values and add MAXLINES=1 variable which will force all values to be listed in one row
      #-----------------------------------------------------------------------------
      # SPOOLID values report in one row
      #-----------------------------------------------------------------------------
      REPORT = SPL
      INCLUDE = IE_TYPE=CT_PIPE
          COLUMN =  17: L : "5'"+"-"+LINENUMBER+"-"+SPOOLID
          COLUMN =  2: R : ";"
          MAXLINES = 1

          GROUP  = SPOOLID
          SORT   = SPOOLID:N
          SEP    = @  
          SORTHEADERS = 0
          NODE = 61
      END

      See sample in picture below:

    4. Generate Isometrics and verify the results


    5. If there is need to change the position or edit format of this report, you can refer to this wiki article by clicking here and do all required changes.
    6. Save all changes, generate Isometrics and verify the results.

    See Also


    Comments or Correction?

    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!

    • OpenPlant Modeler
    • Bill of Materials
    • AutoPLANT Modeler
    • property
    • one Row
    • OpenPlant Isometrics Manger
    • values
    • list
    • Share
    • History
    • More
    • Cancel
    • Kestutis Mitkus Created by Bentley Colleague Kestutis Mitkus
    • When: Wed, Feb 15 2017 7:14 AM
    • Kestutis Mitkus Last revision by Bentley Colleague Kestutis Mitkus
    • When: Wed, Dec 19 2018 2:32 AM
    • Revisions: 6
    • 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

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