I have many alternative reports for an IR on a page. On a different page I will generate links that lists these reports and I want that when I click on one, the correct alternative report is selected when I land on the page.
But the problem is that this report has a lot of data, so it takes maybe 2 seconds before it refreshes completely, so this is not seamless. I was wondering, can we default the IR to the alternative report we want but in PL/SQL?
I've looked at the APEX_IR package, but you can only clear, reset and add filters, but I don't think you can select an existing report so it is selected when the page is loaded. I know I could built the report I want using filters dynamically, but these reports have more than just filters (ex: sorts).
report_id column of apex_application_page_ir_rpt can help us uniquely identify each saved report.
We can assign this report_id value to a page item and this page item can be put in the Report ID Item text box of the Advanced section of the Report Attributes page of the IR.
Kindly mark the reply as helpful/correct if it solves your problem
Pleasure is mine :-). Check more such tricks in my book that projects APEX as a reporting solution and also talks about integrating a number of other reporting products with APEX.
Detail description can be found at Vishal's blog: Description of my book on Oracle APEX 4.2 reporting and book is available at Oracle APEX 4.2 Reporting | Packt Publishing