aspose file tools*
The moose likes Other Open Source Projects and the fly likes iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)" Watch "iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)" New topic
Author

iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)

Craig Taylor
Ranch Hand

Joined: Jul 17, 2008
Posts: 64
I have a jasper report that has a query in the form of :
<code>
select blah from blechTable where
($P{value} is null) OR
(blahColumn in ( $P{value} ) )
</code>
The code runs fine when the parameter has a value of null. The code runs fine when the parameter has a value of value1.

I'm trying to get the report to work when I pass in value1,value2 as the parameter for when the blahColumn is equal to either of the 2 values.

Backing database is Postgres.
 
jQuery in Action, 2nd edition
 
subject: iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)
 
Similar Threads
Problem with xalan in a comparison along xpath axis
Ajax : how to replace another option list?
postgres pool with Tomcat 4.1
Replacing a word in a text file
Display of Latin Characters