 passing data parameters to reports [message #111570] |
Thu, 17 March 2005 09:48  |
 |
zoltanp
Messages: 58
Registered: March 2005
Location: Hungary
|
Member |
|
|
Hi,
I have a report (6i) with two qwery(Q_1,Q_2) and a link between them.
I passed the query as DATA_PARAMETER from a form:
Add_parameter(pl_id,'Q_1',DATA_PARAMETER,'hataroz');
Add_parameter(pl_id,'Q_2',DATA_PARAMETER,'cimek');
The Q_1 query is running correctly, but Q_2 is empty.
Regards,
Zoltán Patalenszki
|
|
|
|
| Re: passing data parameters to reports [message #111880 is a reply to message #111570] |
Mon, 21 March 2005 08:12  |
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
|
Senior Member |
|
|
If the SQL is evaluating the parameter in Q2, you need to have a reference in Q2 to the parameter. The data link will not do this for you as it sounds you left the reference to the second parameter out of Q2. You need it in the WHERE clause.
Another possibility if you did not forget the reference to the parameter is that the conditions completely filter out all the data for the Q2. Run the query (Q2) independently in SQL*Plus or TOAD to see what result set you are getting.
HTH,
Steve
[Updated on: Mon, 21 March 2005 14:19] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
