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

Home -> Community -> Usenet -> comp.databases.oracle -> Running web Report from web Form

Running web Report from web Form

From: Miran Kopmajer <miran.kopmajer_at_eurosplet.si>
Date: 16 Mar 2004 23:01:12 -0800
Message-ID: <45a19c11.0403162301.1e3846ab@posting.google.com>

Hello!  

I developed a form with Forms 9i and I'd like to call a report named 'DOBAVITELJI' with pressing print key.
Below is my KEY-PRINT trigger:  

DECLARE
 repid report_object;
 v_rep varchar2(100);
-- rep_status varchar2(20);
BEGIN
  repid := find_report_object('DOBAVITELJI');

  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,RUNTIME); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,PREVIEW); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'html'); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_server'); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=no' ); 
  v_rep := RUN_REPORT_OBJECT(repid);
END;   When I hit print key I get answer  

FRM-41214:Unable to run report.  

I invoked report to Navigator object. Is there any difference between SET_REPORT_OBJECT_PROPERTY in trigger and setting reports property in PROPERTY PALETTE Can you help me?
THX, Received on Wed Mar 17 2004 - 01:01:12 CST

Original text of this message

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