Passing variables from forms 4.5 -> Reports 2.5

Passing variables from forms 4.5 -> Reports 2.5

Post 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

 
 
 

Passing variables from forms 4.5 -> Reports 2.5

Post 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

 
 
 

1. Oracle Applications Developer, SQL, Forms 4.5, Reports 2.5, Contract

Reference: CIX/NM 708 Oracle Financials
Developer with AR
Type: Contract
Job Title: Oracle Applications Developer, SQL,
Forms 4.5, Reports 2.5
Vacancy: Oracle Financials developer needed
for a National Company.  Experience with SQL,
Forms 4.5 and Reports 2.5 is a must. Also
experience with Oracle Financials 10.7. Module
require is Account Receivables. Will be
involved in setting up, design & customising.
Location: Scotland - Nr Edinburgh
Start date: 22nd March 1999
Duration: 4 weeks + ext.
Rate/Salary: Application Centre's Square Deal
Agency: Application Centre Ltd.
Contact: Nicola Mullarkey
Telephone: 0171 354 5056 or Mobile 0973 307
470
Fax: 0171 354 2373

Subject: Oracle Applications Developer, SQL,
Forms 4.5, Reports 2.5, Contract

2. How to store object in Database (Oracle 8.0.5)?

3. Oracle Applications Developer, Reports 2.5, Forms 4.5.,

4. I am new...

5. Oracle Financials Developer, Reports 2.5, Forms 4.5., Contract

6. JDBC-ODBC bridge

7. LONDON - ORACLE DEVELOPER, Forms 4.5, Reports 2.5, Visual Basic - To 40K plus benefits

8. Oracle Manufacturing rel 10.7, Forms 4.5, Report 2.5, Techie, Contract

9. Oracle Analyst Programmer, Developer 2000, Forms 4.5, Reports 2.5, Permanent

10. Oracle Manufacturing Retrain, Des2000, Forms 4.5, Reports 2.5, Permanent

11. wanted developer 200, forms 4.5 - 5.0, reports 2.5