posted 15 years ago
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.