Home » Developer & Programmer » Reports & Discoverer » how to pass a parameter from 'Parameter Form' to the query, where 'IN' Clause is used
how to pass a parameter from 'Parameter Form' to the query, where 'IN' Clause is used [message #89081] Thu, 28 August 2003 04:52 Go to next message
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);
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 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
you should mention your oracle reports and database versions!
Previous Topic: discoverer
Next Topic: Show PDF document (run pdf viewer) from report
Goto Forum:
  


Current Time: Fri May 24 21:58:40 CDT 2024