| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> Re: Running web Report from web Form
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 Wed Mar 17 2004 - 19:23:10 CST
![]() |
![]() |