Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Reports and 10g
Hi,
I can't get an preview for a report. We use an Oracle 9i database and the 10g forms and report services on a W2k machine.
1.) This print the report whitout any error.
report_id:= find_report_object('REP_DUMMY');
Set_Report_Object_Property(report_id, REPORT_EXECUTION_MODE, RUNTIME); Set_Report_Object_Property(report_id, REPORT_COMM_MODE, SYNCHRONOUS); Set_Report_Object_Property(report_id, REPORT_DESTYPE, PRINTER); Set_Report_Object_Property(report_id, REPORT_DESNAME, 'KYOCERA'); Set_Report_Object_Property(report_id, REPORT_OTHER, 'paramform=no
module=testreport.rdf');
ReportServerJob := run_report_object(report_id, list_id);
2.) I try to preview the report with
report_id:= find_report_object('REP_DUMMY');
Set_Report_Object_Property(report_id, REPORT_EXECUTION_MODE, RUNTIME); 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_DESFORMAT, 'HTMLCSS'); Set_Report_Object_Property(report_id, REPORT_DESNAME, 'DUMMY'); Set_Report_Object_Property(report_id, REPORT_OTHER, 'paramform=no
module=testreport.rdf');
I got error "REP-87: Value for DESTYPE must be SCREEN, FILE, PRINTER, MAIL, INTEROFFICE, SYSOUT, PREVIEW" 3.) Then I try same as above with
Set_Report_Object_Property(report_id, REPORT_DESTYPE, SCREEN);
or
Set_Report_Object_Property(report_id, REPORT_DESTYPE, PREVIEW);
I got "REP:0549: In batch mode destination must be FILE, PRINTER, MAIL
or SYSOUT".
Why the report server use batch mode? I explicitly set the execution
mode to RUNTIME.
In the file rwservlet.properties an entry SERVER_IN_PROCESS=YES. With DIAGNOSTIC=YES and TRACEOPTS=TRACE_ALL I can't find anything helpfull in the trace files.
What do I wrong? Where is the failure?
thanks
Frank
Received on Wed Dec 01 2004 - 12:18:34 CST
![]() |
![]() |