OraFAQ Forum: Reports & Discoverer » one parameter multipole valus

Home » Developer & Programmer » Reports & Discoverer » one parameter multipole valus

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

one parameter multipole valus [message #242878]

Tue, 05 June 2007 07:00

oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka

Member

sir,
my problem is peramater pass in report
my query

select * from emp
where empno in('123','456','4875');

this query i craete a report ,but my problem is parameter when a user
will input emp no in one text field
user input sample

123,456,4875

then report will be generated,however i pass multipole emp no in one parameter in oracle report.

masud iqubal(DHAKA,BANGLADESH)

Report message to a moderator

Re: one parameter multipole valus [message #243015 is a reply to message #242878]

Tue, 05 June 2007 13:40

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Are you working with Discoverer or Reports?

Report message to a moderator

Re: one parameter multipole valus [message #243083 is a reply to message #243015]

Wed, 06 June 2007 00:31

oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka

Member

I am working reports.....

Report message to a moderator

Re: one parameter multipole valus [message #243112 is a reply to message #242878]

Wed, 06 June 2007 02:25

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

as long as there is a separator, comma in your case, you can manipulate that string into three parameter. Or, use lexical parameter when you catch that parameter in report.
do it like this:

where 1=1
&p

where &p is equivalent to 'AND empno in('123','456','4875')'

[Updated on: Wed, 06 June 2007 02:26]

Report message to a moderator

Previous Topic:	HOW TO RUN REPORT FROM FORM?
Next Topic:	plz my report it not so fast urgent!!!!!!!!!!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 00:59:48 CST 2024