Home » Developer & Programmer » Reports & Discoverer » passing number of parameteres in a single parameter
passing number of parameteres in a single parameter [message #224994] Fri, 16 March 2007 07:59 Go to next message
sri_rao85
Messages: 25
Registered: September 2006
Junior Member
hi all
i am getting a small prob like this

i had a report woth the parameter of DEPTNo there i can give 10 the report will come.

but according to my requairment i want to pass the parameter like this 10,20,30 ,the report had to come as per the parameteters.how is it possible.
if anybody know pleaze replay
bye

Re: passing number of parameteres in a single parameter [message #225178 is a reply to message #224994] Sun, 18 March 2007 20:40 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Try to make it string so it can handle that string then manipulate that string on reports or if you are using that on your query, then just put some thing like this. 'deptno in (1,2,3,4)'.
Re: passing number of parameteres in a single parameter [message #226718 is a reply to message #224994] Mon, 26 March 2007 05:08 Go to previous message
bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore
Member
Hi!

Use lexical parameters for this.
e.g.

SELECT *
FROM emp
WHERE deptno IN (&deptnos)
OREDER BY 1


Bhupinder Singh
Previous Topic: urgent run report with in report
Next Topic: REP-3300 fatal error in tool object store
Goto Forum:
  


Current Time: Thu Dec 08 16:21:33 CST 2016

Total time taken to generate the page: 0.12834 seconds