i ran into issues with this last year in 6i forms/reports without 9iAS. I cant remember for certain if it was exactly the same thing, but I believe the problem had to do with the alias of my report server. Certain characters could not be viewed. IT was an undocumented 'feature'. I cannot remember for certain. though there was material on metalink about it.
also go to www.fatcity.com and sign up for the ODTUG Developer listserv. This is more of a backend forum so you may get better answers there.
>
> From: "Nguyen Thanh Hai" <[Email Address Removed] Date: 2003/05/30 Fri AM 12:38:44 EDT
> To: "LazyDBA.com Discussion" <[Email Address Removed] Subject: Run a report from form 9iAs Form services on linux advanced 2.1
>
> I have a procedure to run a report from form 9iAs Form services on linux
> advanced 2.1)
>
> PROCEDURE RUN_REPORT IS
>
> repid REPORT_OBJECT;
>
> v_rep VARCHAR2(100);
>
> rep_status VARCHAR2(20);
>
> BEGIN
>
> repid := find_report_object('REPORT10');
>
> SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
>
> SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
>
> SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
>
> SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'htmlcss');
>
>
> SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'authid=orcladmin/manager1
> ');
>
>
> SET_REPORT_OBJECT_PROPERTY(repid,REPORT_FILENAME,'a_rpt_Order.RDF');
>
>
> SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_oralinux.soft.cmc.co
> m.vn');
>
> 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*/
> WEB.SHOW_DOCUMENT('http://oralinux.soft.cmc.com.vn:7778/reports/rwservle
> t/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'
> ||'server=rep_oralinux.soft.cmc.com.vn', '_blank');
>
> ELSE
>
> message('Error when running report');
>
> END IF;
>
> END;
>
> It always displays error FRM-41214: Unable to run report
>
> and FRM-41213: Unable to connect report server
> rep_oralinux.soft.cmc.com.vn
>
> What should I do ?
>
> Please reply to me to [Email Address Removed] <mailto:[Email Address Removed]
>
> Thank you very much
>
>
>
>
Oracle LazyDBA home page