I have developed a page say "Saved Reports" showing the list of saved reports of a user. In the same page, I have provided link to call each saved report. by creating branching using Branch to function returning a Page
I copy the function below:-
WHERE application_id = :APP_ID
AND page_title = :P14_Report_name;
WHERE flow_id = :APP_ID
AND application_user = :APP_USER
AND name = :P14_Report_name;
IF x_page_id IS NULL THEN
When I click the link it is going to the correct page that contains the saved report. If the page has more than one saved report the first report is listed. I want to show the correct report (i.e. which is called from "Saved Reports" page).
I have to pass the saved report name and change the saved report to the passed report in the IR saved report dropdown list which is not currently happening.
I can get the saved report name that is shown to the user by the script below
'ID: ' +
', Text: ' +
But I cannot change the report to the required one. I tried
But no luck.
Please help me to resolve.
I am using Oracle APEX version: 4.1.0.00.32
Any help on this is highly appreciated.
Thanks in advance.
Edited by: ravichandran.swaminathan on Nov 15, 2012 10:42 PM
If you use the PAGE_ID you get the default report on the IAR page.
If you fetch the column REPORT_ALIAS from WWV_FLOW_WORKSHEET_RPTS ( and not the PAGE_ID ) and run that "page" then you should get the desired stored IAR.
These aliases can also be seen on the Saved reports tab of the Interactive report region, in version 4.2 there is also an example of a link to the saved report on that page but I'm not 100%sure if that was also there in 4.1 (just check and see).
f?p=101:10:&APP_SESSION.:IR_REPORT_47167 in which 47167 is the alias for the saved report.
But probably your problem is that you're using user reports and not saved default reports. Behind the user reports I don't see an alias so I'm not sure if this way will work for you. I will try to check when I find time (might take a while).