Excel - Exporting More Info Rows

If your report contains a Data Table and you're using the More Info Row element to show/hide additional detail data within the table, you may want the detail rows (when visible) to be exported along with the main table data.

To enable this, as shown above, set your Target.Native Excel element's Keep Show Elements attribute to True, and leave the Export Data Table ID setting blank. If you place a value here, you risk not displaying all of the rows in the spreadsheet.

Keep Show Elements works with Action.Show Elements (used to show/hide the More Info Row) so that items that have been shown or hidden by the user remain that way when the report is re-displayed or exported.