Calling Reports from Forms [message #89368] |
Sat, 28 February 2004 07:39 |
babu
Messages: 16 Registered: September 1999
|
Junior Member |
|
|
Hi,
I am calling a report from form by passing 2 values, basically parameters. And in reports how to refer those values passed through form parameters( based on these values I want to fetch data in report).
For Example:
I have a table called place in which i have two columns namely id, place, crdate. I am passing two dates through form parameters and i need to fetch data in report between these two dates.
Can anyone help me.
|
|
|
Re: Calling Reports from Forms [message #89393 is a reply to message #89368] |
Thu, 11 March 2004 02:00 |
J.S.Rajkumar
Messages: 20 Registered: March 2004
|
Junior Member |
|
|
Hi
I think you need to create a user parameter in your report with the same parameter name you have in the parameter list.
You can use the parameters you have created in report for your query between :p_1 and :p_2
Try this, This is the way we pass parameter between forms. think this should work with reports also.
thanks
|
|
|