Home » Developer & Programmer » Forms » Parameter passing in report(multiple)
Parameter passing in report(multiple) [message #243079] Wed, 06 June 2007 00:00 Go to next message
nahian
Messages: 7
Registered: June 2007
Location: Bangladesh
Junior Member
sir,
my problem is paramater 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.

Waliul arefin nahian(DHAKA,BANGLADESH)
Re: Parameter passing in report(multiple) [message #243107 is a reply to message #243079] Wed, 06 June 2007 02:11 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Check the string if it contain comma, then manipulate it as you want.
Re: Parameter passing in report(multiple) [message #243109 is a reply to message #243107] Wed, 06 June 2007 02:16 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
It's another example of a "varying IN list". Check out my reply here.

MHE
Previous Topic: Automatically display unique ID for new record (merged)
Next Topic: report from form
Goto Forum:
  


Current Time: Thu Dec 08 10:27:50 CST 2016

Total time taken to generate the page: 0.09462 seconds