OraFAQ Forum: Reports & Discoverer » how to pass a parameter from 'Parameter Form' to the query, where 'IN' Clause is used

Home » Developer & Programmer » Reports & Discoverer » how to pass a parameter from 'Parameter Form' to the query, where 'IN' Clause is used

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to pass a parameter from 'Parameter Form' to the query, where 'IN' Clause is used [message #89081]

Thu, 28 August 2003 04:52

padma raibagi
Messages: 1
Registered: August 2003

Junior Member

how to pass a parameter from 'Parameter Form' to the query, where 'IN' Clause is used.
Example:
We want to pass 'a','b','c' as parameter where SUP_LIST is our user parameter in report.
And our query looks like :
select supname
from supplier
where sucode in (:SUP_LIST);

Report message to a moderator

Re: how to pass a parameter from 'Parameter Form' to the query, where 'IN' Clause is used [message #89099 is a reply to message #89081]

Thu, 18 September 2003 07:29

magnetic
Messages: 324
Registered: January 2003

Senior Member

you should mention your oracle reports and database versions!

Report message to a moderator

Previous Topic:	discoverer
Next Topic:	Show PDF document (run pdf viewer) from report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 12 23:25:34 CDT 2025