Home » Developer & Programmer » Forms » could show report output on screen (Forms10G, Database 10GR2 , XP)
icon4.gif  could show report output on screen [message #358997] Thu, 13 November 2008 03:45 Go to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: How to configure and install report server 10g, not able to run a report from forms
Next Topic: Production deployment cost
Goto Forum:
  


Current Time: Sat Dec 10 11:13:47 CST 2016

Total time taken to generate the page: 0.07964 seconds