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

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

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

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 11:57:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.