Hi All,
1. In my Page I have interactive report and more than one classic reports and some classic reports are pl/sql function returning procedures.
I need to export all these reports from a page in a single excel sheet with a single click.
Using APEX Process type Plugin IR report to excel. I am able to acheive all the reports in a single excel file with a single click.
- Process Type Plugin - (IR) Report to Excel (xlsx)
But each one report are on individual sheet in a excel file.
I need to export all the reports in single excel sheet only, but not as each report in each sheet.
2. For one report , I used pl/sql fuction returning process for returning dynamic column headers.
For this when I used Process Type plugin to export the reports to excel.
In this I am unable to get dynamic column headers for a report in the downloaded excel.
Is there any method or modifications require in the source to export all the reports of a page to excel in single sheet and display with dynamic column headers.
Awaiting for any suggestion.
Thanks in Advance
Vaishalini