So I have a page with 5 tabs and 5 Interactive Reports. I can use the action button to create individual CSVs for each IR, but is there a way to have a single button to create 1 Excel with (in this example) 5 worksheets, 1 per IR.
I have a working solution for this, which basically runs a PL/SQL to create the Excel file. Duplicating the SQL within the IR to fetch the data. I just wondered if there is a way within APEX to do this directly.