how could I use MENU to call report [message #335424] |
Tue, 22 July 2008 02:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
amdabd
Messages: 91 Registered: November 2007 Location: My Computer
|
Member |
|
|
hi, all
I'm using the following procedure to call Reports within formPROCEDURE rep_applic_data
IS
repid report_object;
v_rep VARCHAR2 (100);
rep_status VARCHAR2 (20);
BEGIN
repid := FIND_REPORT_OBJECT ('REP_APPLIC_DATA');
SET_REPORT_OBJECT_PROPERTY (repid, report_desformat, 'htmlcss');
SET_REPORT_OBJECT_PROPERTY (repid, report_server, 'repserver10g');
v_rep := RUN_REPORT_OBJECT (repid);
rep_status := REPORT_OBJECT_STATUS (v_rep);
WHILE rep_status IN ('RUNNING', 'OPENING_REPORT', 'ENQUEUED')
LOOP
rep_status := REPORT_OBJECT_STATUS (v_rep);
END LOOP;
IF rep_status = 'FINISHED'
THEN
web.show_document ( 'http://localhost:8889/reports/rwservlet/'
|| 'getjobid'
|| SUBSTR (v_rep, INSTR (v_rep, '_', -1) + 1)
|| '?'
|| 'server=repserver10g',
'_blank'
);
ELSE
MESSAGE ('Error when running report');
END IF;
END;
and define the report path within the NODE REPORT within the module ,
please, how could I use MENU to call the report
thanks
|
|
|
|
Re: how could I use MENU to call report [message #339300 is a reply to message #339217] |
Thu, 07 August 2008 04:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
amdabd
Messages: 91 Registered: November 2007 Location: My Computer
|
Member |
|
|
djmartin wrote on Thu, 07 August 2008 01:55 | Have you tried writing code that calls this procedure from a menu?
|
hi, dear David
I try many times without any point of success (Perhaps I mis-understand the mechanism) ,
but, I tried using an empty CANVAS on separate Form with PRE-FORM triger calling the report procedure
then,
in menu ,just call this form , the report works properly.
until I get my point, this method works nice.
thanks
-
Attachment: rep1.PNG
(Size: 78.79KB, Downloaded 1063 times)
|
|
|
|
|
|
|