Home » Developer & Programmer » Reports & Discoverer » error in running report
error in running report [message #541188] Sun, 29 January 2012 06:21 Go to next message
hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello,
I tried to call report from form (10 g) but it gave me this error "unable to connect to the report server".

The program (database and forms) in my computer.
Someone told me I have to run report server by this code to run the report

rwserver server=hmarawan autostart=yes

My code as follows :
--------------------------------------
Declare
rep_status varchar2(20);
repid Report_Object;
v_des_format varchar2(60):='PDF';
repserver varchar2(25):='hmarawan';
v_rep varchar2(100);
rep_name varchar2(100):='DRIVERS';



Begin
repid := Find_Report_Object(rep_name);
set_report_object_property(repid,report_execution_mode,Runtime);
set_report_object_property(repid,report_comm_mode,Synchronous);
set_report_object_property(repid,report_DesType,File);
set_report_object_property(repid,report_DesFormat,v_des_format);
set_report_object_property(repid,report_Server,repserver);
SET_REPORT_OBJECT_PROPERTY(REPID,REPORT_OTHER,' paramform=no');
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' or rep_status is NULL then
null;
end if;

end ;

---------------------------------------
can anyone help me
Re: error in running report [message #541191 is a reply to message #541188] Sun, 29 January 2012 08:16 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Check you code again.We should need below code to run the report.
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'|| vjob_id ||'?server='||repsvr,'_blank');

Previous Topic: HOW TO create lexical references
Next Topic: Code to compute Price INCL of VAT
Goto Forum:
  


Current Time: Thu May 28 04:04:48 CDT 2020