Exporting More Info Row to Excel
I have a data table where each row can be expanded to show more details in a subtable — done that using a More Info Row element and opening a subreport there. Now if I try to export that data table, having set the Keep Show Elements set to true, the table only gets exported up to the first opened More Info Row. Like, if I have this in the report:
table-1-name-1 | table-1-description-1
table-1-name-2 | table-1-description-2
table-2-more-details-2
table-1-name-3 | table-1-description-3
table-1-name-4 | table-1-description-4
table-2-more-details-4
And I do an export, I only have this in the spreadsheet:
table-1-name-1 | table-1-description-1
table-1-name-2 | table-1-description-2
table-2-more-details-2
Is there some configuration I am missing?
-
Hi Anton,
There are few different considerations for export. If you are using rapid export, then this does not support more info rows (More details: https://devnet.logianalytics.com/hc/en-us/articles/4402865768087-Export-To-Native-Excel). If you want to use rapid export i.e. you're need to use the data to import into another application and formatting is not a high priority, then the normal thing to do is to create a new report definition for export only, with a data table and a data layer that has been flattened i.e. all parent columns repeated for each detail row. The end user will not load this report, but the export will utilise it instead of the onscreen visualisation.
If you wish to "retain" the formatting of the onscreen visualisation in the export then you will need to use the native excel export option. This can be used with both the sub-report (include-frame) mode and the sub data table mode. You should set "Keep Show Elements" to true and don't add the table id (!important). If you need to set the table id due to multiple tables in the dashboard/report, then you should also add the whole table definition to a separate, export only, report definition - shared elements would be a good way to share the table definition between report definitions in this case so that you don't have multiple definitions that may fall out of sync.
If you set the "Show Modes" attribute on the more info row element to "None" it will only export visible more info rows or just the parent level rows. You should change this to one of the "rdExport..." selections or parameterise the show modes attribute, and pass "All" or one of the "rdExport..." modes as a link parameter.
I hope this helps
0 -
Thanks. Glyn,
we've settled for a spreadsheet with two pages in the meantime, one contains the "main" table, the second — all available details from the More Info elements. Thanks for the tips though, will keep them in mind next time we run into this problem.
0
Please sign in to leave a comment.
Comments
2 comments