Home » Developer & Programmer » Forms » Developer2000
Developer2000 [message #81828] Tue, 25 March 2003 04:57 Go to next message
Zaheen
Messages: 2
Registered: March 2003
Junior Member
How i can pass parameters directly from forms to run a parametric report(Without using parametric form)?
Re: Developer2000 [message #81829 is a reply to message #81828] Tue, 25 March 2003 05:09 Go to previous messageGo to next message
utsav
Messages: 94
Registered: March 2003
Member
Hey,

Since u dont want to use the parameter, u r calling report from form and u want report output to be filtered as per the parameters.

Dont use parameters, use the record group instead. Pass the data of the recordgroup to the report. The main advantage will be that wont have to execute the query again in report.

If u still have problems, let me know.

utsav.
Re: Developer2000 [message #81836 is a reply to message #81828] Tue, 25 March 2003 09:05 Go to previous message
waris
Messages: 115
Registered: November 2001
Senior Member
Hi Zaheen,

Add this following parameter before calling ur report thru RUN_PRODUCT..this parameter will hide the report parameter form and directly shows ur report...

/*
**Pass a Parameter into PARAMFORM so that a parameter dialog will not appear
**for the parameters being passing in.
*/

Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');

Hope this helps u!!!

Cheers
waris
Previous Topic: Problem in Running Oracle Forms 9i
Next Topic: How to make TOAD connect to Oracle 9i ??
Goto Forum:
  


Current Time: Sat Apr 20 03:29:58 CDT 2024