Applies To
Product(s):	OpenPlant PID CONNECT Edition
Version(s):	Update 9 (10.09.00.74)
Environment:	Windows 10 (64-bit)
Area:	Customization
Subarea:	Reports
Original Author:	Ashutosh Patil, Bentley Product Advantage Group

Background

In OPPID CE, We are able to extract OOTB Valve Report easily which gets reflected as shown below. But sometime as per requirement there may be need of Pipeline Number should get reflected into Same report. And Pipeline Number is not reflected even when customization is done in valve report by adding Line Number into it.



This Wiki will help user to do the customization and Reflect Pipeline Number in OOTB Valve Report through Reporting Designer using OPPA in OpenPlant PID CE.

Steps to Accomplish

1. Since the Report need to be fetched from OPPID CE, So kindly go to OPPA CE.
   
   
   
   
2. Select the required Workspace→Workset →Select application OPPID CE →Reporting Designer.
   
   
   
   
3. In OOTB report for Valve considering Metric Project, We have Name, Rating & Size already defined.
   
   
   
   
4. To add Pipeline Number OR Line Number we add another row below Size stating as PipeLine Number.
   To add Pipeline Number first pull the Page Footer below and then select Size - table A written in red along with Size(valve)table-B.Right click and select Copy.
   
   
   
   
5. Paste in open space below Size table row written in red as shown below.And both table if Size and Size(valve) gets pasted as shown below.
    
   
   
   
6. Rename the new Row as shown below
   - For renaming Size click on small arrow which is on Right top corner of its table. Label Task window will get launched. In that window in Text- filled rename SIZE to PIPELINE NUMBER as shown below. Or double click also helps to edit the text.
   - For rearranging Size(Valve) as shown in last image to Line Number (Valve).Click on small arrow which is on Right top corner of its table.Select Data Binding to Line Number(Valve) from Size(Valve)
    
   
   
   
7. Click on Save for all the changes done and go to OPPID CE.
   
   
   
   
8. In OPPID CE, Click External Report. After Report Selector window gets Launched Hit on Refresh-A, Click on Valve to generate Report-B as shown in image below:
   Valve Report would be generated with Pipeline Number -C as just TEXT but not reflecting the exact Pipeline Number on which respective valve are place.
   
   
   
   This is due to Line Number property on Valve does not fetch Pipeline Tag Number or Name on which it is placed
   
9. To Reflect PipeLine Number to get reflected on Valve Properties we would be proceeding to do few customization in Schemas at Workset level of OPPID
    
10. Click on Class Editor directly on Icon or through selecting OPPID CE application then Tools and last Class Editor as shown below
    
    
    
    
    
    
11. Considering OpenPlant_ Metric : Open the OpenPlant_PID.01.08.ecshema.xml & supplement it with OpenPlant_PID_Supplemental_Design.01.08.ecshema.xml through below default std path. (OpenPlant_PID.01.08.ecshema: Std Path(C:\ProgramData\Bentley\OpenPlant CONNECT Edition\Configuration\Workspaces\WorkSpace\WorkSets\OpenPlantMetric\Standards\OpenPlant\Schema
    
    
12. Go to Valve and check Line Number property which is existing already and is faded as shown below
    
    
     
13. To Reflect Line Number in reports of Valve we need to cascade Pipeline Number Tag on to Line Number property of Valve.
    Go to Piping Component select Line Number property click on Override and add Custom Attributes as shown below and make their location to Supplemental Design
    -Calculated EC property Specification
    -Category
    -Property Display Filter.
    
    
    
    
    
14. In Calculated EC expression, Use Expression as shown below on Piping Component class, Line Number property such that it will reflect on to all child classes below mainly valves as well.
    this.GetRelatedInstance("SEGMENT_HAS_PIPING_COMPONENT:1:PIPING_NETWORK_SEGMENT").GetRelatedInstance("PIPELINE_HAS_SEGMENT:1:PIPING_NETWORK_SYSTEM").NAME
    
    
     
15. Go to Valve and check same expression is getting reflected on Line Number property as well or not along with category and Property display filter custom attribute.
    
    
    
    
16. Save the Schema and relaunch OPPID CE and Reporting Designer.
    
    
    
    
17. And generate the Valve report again through External report. And it can been seen that Pipeline Number getting reflected in Valve report as well.
    
    
    
    Thus meeting one of the User requirement where PipeLine Number is getting included OOTB Valve Report.

See Also

communities.bentley.com/.../fundamentals-of-reporting-designer-using-openplant-project-administrator-connect-edition

Still a Problem?

If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround