This discussion is archived
4 Replies Latest reply: Oct 11, 2013 8:10 AM by reggieh RSS

Can we set the alternative IR reports with PL/SQL?

reggieh Newbie
Currently Being Moderated



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.


Right now, I retrieve the Report ID by querying the APEX Views based on the Report Alias, then I have a dynamic action that selects the report in JavaScript:




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).




  • Correct Answers - 10 points
  • Helpful Answers - 5 points