| error in running report [message #541188] |
Sun, 29 January 2012 06:21  |
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  |
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');
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
