| Reports where_clause [message #89699] |
Tue, 29 June 2004 03:09  |
tt
Messages: 16
Registered: September 2000
|
Junior Member |
|
|
Hi,
I new with Oracle Reports and i'm using version 9i.
Question : If i have two different forms calling the same report, is it possible to change the where_clause of the report query depending on which form i'm printing from ???
Any help will be very much appreciated.
|
|
|
|
| Re: Reports where_clause [message #89713 is a reply to message #89699] |
Fri, 02 July 2004 05:01  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Make use of Lexical parameters.
Build the where clause in your form & send it to the reports lexical parameter e.e. &P_query.
HTH
Regards
Himansh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
