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

communities.bentley.com/.../modifying-text-and-annotation-settings
communities.bentley.com/.../how-to-change-text-font-size-color-and-location-in-bom-using-text-nodes

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!