| Reports... Please can anyone help... this is urgent... [message #147207] |
Wed, 16 November 2005 06:08  |
VSPB
Messages: 27
Registered: August 2005
|
Junior Member |
|
|
hi
when i try to run my report from form i get this error
FRM-41214: Unable to run report
i want to preview my report. reports from other forms are running properly. i've matched the code and other properties of this form with the others. Nothing is different. I searched for this error in the forum, but couldnt find anything that could help. this is my code...
declare
report_id Report_Object;
ReportServerJob VARCHAR2(100);
vc_rep_status VARCHAR2(100);
vjob_id VARCHAR2(100);
repsvr varchar2 (50) := 'slrepserver';
BEGIN
report_id:= find_report_object('report1');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,cache);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,repsvr);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'paramform=no rp_sb_id='||:sb_id);
ReportServerJob:=run_report_object(report_id);
vjob_id := substr(reportserverjob,length(repsvr)+2);
vc_rep_status := REPORT_OBJECT_STATUS(ReportServerJob);
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;
this runs perfectly for other forms.
Help...
Thank you
Vaidehee
[Updated on: Thu, 17 November 2005 00:11] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
