| frm-41213 and rep-51018 [message #171245] |
Tue, 09 May 2006 02:37 |
tahir_mehmood
Messages: 10
Registered: August 2004
|
Junior Member |
|
|
hi to all please help me i am facing great diffuclty in running my 9i report on the web.
When i use follwing code to run report
declare
report_id Report_Object;
ReportServerJob VARCHAR2(100);
vc_rep_status VARCHAR2(100);
vjob_id VARCHAR2(100);
repsvr varchar2(21) := 'rep_tahir-mehmood';
BEGIN
report_id:= find_report_object('AOTS');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,file);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESNAME,'rpout1.html');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'HTMLCSS');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,repsvr);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER, 'paramform=no');
ReportServerJob:=run_report_object(report_id);
vjob_id := substr(reportserverjob,length(repsvr)+2);
vc_rep_status := REPORT_OBJECT_STATUS(ReportServerJob);
WHILE vc_rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED', null)
LOOP
vc_rep_status:=REPORT_OBJECT_STATUS(ReportServerJob);
message('ans='|| vc_rep_status || '?') ;
END LOOP;
IF vc_rep_status='FINISHED' THEN
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'|| vjob_id ||'?server='||repsvr,'_blank');
ELSE
message ('Report failed with error message '|| vc_rep_status);
END IF;
END;
frm-41213 error occur and when i use follwing code to run report
declare
rep_url varchar2(2000);
begin
rep_url:='/reports/rwservlet?server=rep_tahir-mehmood&report=C:\Retail_app\aots.rdf'
||'&desformat=htmlcss&destype=cache&userid=¶mform=no';
set_custom_property('cash_sale.userid_bean',1,'WRITE_LOGOUTPUT','true');
set_custom_property('cash_sale.userid_bean',1,'ADD_USERID',
get_application_property(username)||'/'||
get_application_property(password)||'@'||
get_application_property(connect_string));
set_custom_property('cash_sale.userid_bean',1,'WRITE_USERID_COOKIE','9i');
SYNCHRONIZE;
WEB.SHOW_DOCUMENT(rep_url,'_blank');
end;
rep-51018 error occur plz help me in this matter
on my e-mail address which is
tahir_mehmood_satti@hotmail.com
tahir_mehmood_satti@yahoo.com
waiting for your replay
tahir satti
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
