OraFAQ Forum: Reports & Discoverer » passing number of parameteres in a single parameter

Home » Developer & Programmer » Reports & Discoverer » passing number of parameteres in a single parameter

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

passing number of parameteres in a single parameter [message #224994]

Fri, 16 March 2007 07:59

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

Report message to a moderator

Re: passing number of parameteres in a single parameter [message #225178 is a reply to message #224994]

Sun, 18 March 2007 20:40

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)'.

Report message to a moderator

Re: passing number of parameteres in a single parameter [message #226718 is a reply to message #224994]

Mon, 26 March 2007 05:08

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 16:38:21 CST 2024