Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Reports and 10g

Reports and 10g

From: Frank Dietrich <ablesoft_at_gmx.de>
Date: Wed, 01 Dec 2004 19:18:34 +0100
Message-ID: <316g82F391p6rU1@individual.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US