Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Murach's Java Servlets and JSP this week in the Servlets 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)
 
Similar Threads
Replacing a word in a text file
postgres pool with Tomcat 4.1
Problem with xalan in a comparison along xpath axis
Display of Latin Characters
Ajax : how to replace another option list?