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);

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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 21:16:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.