Re: Running web Report from web Form

From: AnaCDent <anacedent_at_hotmail.com>
Date: Wed, 17 Mar 2004 17:23:10 -0800
Message-ID: <%R66c.7322$Bg.871_at_fed1read03>


Miran Kopmajer wrote:
> 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,
I'm just the messenger, so don't shoot me.

RUN_REPORT_OBJECT does not work with a Reports Server which has an underscore character ("_") as part of its name. You need to create a Reports Server named something other than "rep_server". Received on Thu Mar 18 2004 - 02:23:10 CET

Original text of this message