Home » Developer & Programmer » Reports & Discoverer » developer 2000 reports 2.5
developer 2000 reports 2.5 [message #89080] Thu, 28 August 2003 04:40
padma
Messages: 22
Registered: April 2001
Junior Member
how to pass a parameter from 'Parameter Form' to the query, where 'IN' Clause is been .
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

Previous Topic: How to Maintain screen parameter of the report
Next Topic: printer on reports
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 20:14:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.