4 Replies Latest reply: Oct 11, 2013 10:10 AM by reggieh RSS

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

    reggieh

      Hi,

       

      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:

       

      gReport.pull($('#P50_IR_REPORT_ID').val(),'REPORT_CHANGED');

       

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

       

      Anyone?