Re: Passing variables from forms 4.5 -> Reports 2.5

You cannot just pass one variable from forms.

The following PL/SQL program unit may help.

Thanks

Prasad Chavali

begin
  cac_id := get_parameter_list('cac_params');   if not id_null(cac_id) then
    destroy_parameter_list(cac_id);
  end if;      

  cac_id := create_parameter_list('cac_params');   

  add_parameter(cac_id,'destype',text_parameter,'preview');

  add_parameter(cac_id,'booking_id',text_parameter,:global.booking_id);

• This parameter will close the Report Server in the Windows Environment add_parameter(cac_id, 'ORACLE_SHUTDOWN', text_parameter, 'YES');
• This paramter will suppress the parameter form add_parameter(cac_id, 'PARAMFORM', text_parameter, 'NO');

 run_product(reports,'receipt',synchronous,runtime,filesystem,cac_id,null); end;

 D. Shah <dipen_at_dcs.rhbnc.ac.uk> wrote in article <6bpvsq$4qr$1_at_us1.rhbnc.ac.uk>...
> Hi,
>
> I am using SQL*Forms 4.5 to pass a variable to SQL*Reports 2.5 as
> follows:
>
>
Run_Product(REPORTS,'receipt',ASYNCHRONOUS,runtime,FILESYSTEM,:global.bookin g_id,null);
>
> ...now how do I USE :global.booking_id (ie variable passed over to
> SQL*Reports 2.5???
> This variable needs to be used in a SELECT clause within the 'Data
> Model' so as to
> extract specific records.
>
> (I would be very grateful if you can give me a step-by-step guide of
> what to do!).
>
> Thanks VERY much in advance!
>
> Dipen
>
Received on Tue Feb 10 1998 - 00:00:00 CET