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 Spring in Action this week in the Spring 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.
 
Consider Paul's rocket mass heater.
 
subject: iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)