Hello,
I'm looking for some help in regards to finding an easy way to Download an IR report directly to XLS format. I am using APEX 5 and I can currently download to csv but this is not sufficient for our client base.
I'm aware that BI Publisher has this functionality but we can't afford to purchase this given the high costs.
I found a plugin called (IR) Report to Excel (xlsx) by Anton Scheffer. I've downloaded and installed the plugin, created the process and download button;
Process
------------
Process point - On load - Before header
Condition Type - Request = Expression 1
Button
-----------
Button Template - Button
Button Type - Normal
Action - Redirect to a page in this application
Page - same page number as the page with the IR, process and button
Request -
For the Request field in the button, Anton's readme said;
"And use as Request the same value you have used in the Condition of the process."
I've not set a Condition in the process only a condition type. I'm a novice in APEX development and therefore I could easily be missing something obvious. Please can someone guide me in the right direction?
When I run the interactive report, I enter a start date, end date (from date picker) and a value from a shuttle. The results are then returned and then i click the download button and nothing happens.
Regards,
David