This discussion is archived
4 Replies Latest reply: Dec 3, 2012 4:18 AM by 973460 RSS

Help required to show the required saved report when the page is opened.

973460 Newbie
Currently Being Moderated
Hi,

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:-
+DECLARE
x_page_id NUMBER;

CURSOR cur_get_page_id
IS

SELECT page_id
FROM apex_application_pages
WHERE application_id = :APP_ID
AND page_title = :P14_Report_name;

CURSOR cur_get_private_page_id
IS

SELECT page_id
FROM apex_040100.WWV_FLOW_WORKSHEET_RPTS
WHERE flow_id = :APP_ID
AND application_user = :APP_USER
AND name = :P14_Report_name;
BEGIN
OPEN cur_get_page_id;
FETCH cur_get_page_id
INTO x_page_id;
CLOSE cur_get_page_id;

IF x_page_id IS NULL THEN
OPEN cur_get_private_page_id;
FETCH cur_get_private_page_id
INTO x_page_id;
CLOSE cur_get_private_page_id;
END IF;

RETURN x_page_id;

END;+

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
alert(
'ID: ' +
$('#apexir_SAVED_REPORTS').val() +
', Text: ' +
$('#apexir_SAVED_REPORTS :selected').text()
);

But I cannot change the report to the required one. I tried
$s($v('#apexir_SAVED_REPORTS'),'56776711684732556');
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.
I

Thanks in advance.
S.Ravichandran

Edited by: ravichandran.swaminathan on Nov 15, 2012 10:42 PM

Legend

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