 could show report output on screen [message #358997] |
Thu, 13 November 2008 03:45  |
kalpeshpatelh7883
Messages: 1
Registered: November 2008
Location: gujarat, ahmedabad
|
Junior Member |
|
|
Hi
i'm new in this forum
i had refer this forum many time when i'm in trouble
i have problem. When i'm running any report through form it will run properly but it could not show me output on screen.
i can view that report output from EM->report server-> finished job
here i'm putting my code which i have write in form
Declare
repid report_OBJECT;
v_rep VARCHAR2(1000);
rep_status VARCHAR2(20);
BEGIN
repid := find_report_object('test1');
SET_report_OBJECT_PROPERTY(repid,report_EXECUTION_MODE,BATCH);
SET_report_OBJECT_PROPERTY(repid,report_COMM_MODE,ASYNCHRONOUS);
SET_report_OBJECT_PROPERTY(repid,report_DESTYPE,CACHE);
SET_report_OBJECT_PROPERTY(repid,report_DESFORMAT,'PDF');
SET_report_OBJECT_PROPERTY(repid,report_SERVER,'rep_hrmscsbu_oracleas2');
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
/*Display report in the browser */
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=rep_hrmscsbu_oracleas2',' _blank');
ELSE
message('Error when running report');
END IF;
END;
please help me.
|
|
|
|
| Re: could show report output on screen [message #359137 is a reply to message #358997] |
Thu, 13 November 2008 18:59  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Get rid of the 'report_OBJECT_STATUS' code and just run the 'WEB.SHOW_DOCUMENT' command.
Search this forum for WEB.SHOW_DOCUMENT and you will find MANY threads where people have had a similar problem.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
