Home » Developer & Programmer » Reports & Discoverer » one parameter multipole valus
one parameter multipole valus [message #242878] Tue, 05 June 2007 07:00 Go to next message
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)
Re: one parameter multipole valus [message #243015 is a reply to message #242878] Tue, 05 June 2007 13:40 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Are you working with Discoverer or Reports?
Re: one parameter multipole valus [message #243083 is a reply to message #243015] Wed, 06 June 2007 00:31 Go to previous messageGo to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
I am working reports.....
Re: one parameter multipole valus [message #243112 is a reply to message #242878] Wed, 06 June 2007 02:25 Go to previous message
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:
  


Current Time: Sun Dec 04 04:16:02 CST 2016

Total time taken to generate the page: 0.04465 seconds