Very Computer

by **D. Sh** » Wed, 11 Feb 1998 04:00:00

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.booking_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

by **Nuno Guerrei** » Thu, 12 Feb 1998 04:00:00

Quote:>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.booking_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

You can't pass variables that way. You need to create a parameter list
(which may contain several variables). See Forms 4.5 Help for creating
parameter lists - they have some examples.

Good luck,

Nuno Guerreiro

Very Computer

Passing variables from forms 4.5 -> Reports 2.5

Passing variables from forms 4.5 -> Reports 2.5

Passing variables from forms 4.5 -> Reports 2.5