Exporting child table data from BIRT(3.7.1) report to CSV in Maximo 7.5.3 with main table

coreyhill

<p>Hey all,<br><br>
I'm currently looking for a way to export the data from both the main table and child table I have nested within it all into a csv on a report I created. After doing some research I've discovered that the data is exported based on the bindings in the report, but I have a business requirement to have it all exported just like the report has.<br><br>
Is there any way to do that or is that functionality not available?<br><br>
Thanks for any help that you can provide.</p>

rdpeterson

<p>Hello.  Can I see a copy of your report?  Are you running the report in Maximo then selecting the Export Data set or Export Report option to export to CSV file?  In my organization, our Work Order List report is bound to a single data set but the data set is a query with sub-queries joining to other tables, etc.  When I run the report and choose the Export Data output option, all fields in the data set including related tables are available to return in the output.  You can also bind sub-queries separately in the Fetch block of data set objects to a main query in the Open block, but it's still a single dataset object for output.  Again, I'd have to see the report to know what's happening for you.</p>