Background

In Bentley Raceway and Cable Management, it is possible to export the custom cable UDAs by using Detail_Cable_Route_List report template. But If you want to export the UDAs along with other cable data in cable route list report templates like Detail_Cable_Route_List II, III and IV, some manual changes to the SQL query in the report template is needed.

You can follow this article to know how you can export custom cable UDAs in Cable Route List reports.

Steps to Accomplish

1. Launch BRCM and open any file from the example project.
   
   
2. Open Output Manager from Output ribbon menu.
   
   
   
   
3. Open Cable Route List IV and Select Resources.
   
   
   
4. Click on Edit Report Template to launch the Report Designer.
   
   
   
5. In Report Designer’s Field List section, you can see that the imported UDA is not in the Report Information list.|
   
   
   
6. Now, look for SQL Query in the Property Grid section and copy it.
   
   
   
7. Open any preferred text editor and paste the SQL Query.
   
   
   
8. Make an entry for the Cable UDA as $(P)_$(S)_ext_Cables.UDANAME in SELECT and GROUP BY.
   For Example: $(P)_$(S)_ext_Cables.ASSETNUMBER.
   
   
   
9. Now go back to BRCM, paste the edited SQL query, and save the report.
   
   
   
10. Close and reopen the Report Designer and you will find the Cable UDA in the Field list.
    Drag and drop the new field list in your report as shown in the image below.
    
    
    
11. Preview the report and you will get the Cable UDA values under the header.
    

See Also

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.

Comments or Corrections?

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!