This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes JasperReport - error with conditional parameter in SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "JasperReport - error with conditional parameter in SQL" Watch "JasperReport - error with conditional parameter in SQL" New topic
Author

JasperReport - error with conditional parameter in SQL

Chengwei Lee
Ranch Hand

Joined: Apr 02, 2004
Posts: 884
I'm trying to have a query that returns all rows if user_id parameter is NULL/empty. The same query should return a specific row if user_id is not NULL/empty. I did some Googling and found the following suggestion. However, when I preview the Jasper report in the iReport, I hit a Oracle missing keyword error. I checked my syntax and it seems to be okay.

Any help is appreciated!



SCJP 1.4 * SCWCD 1.4 * SCBCD 1.3 * SCJA 1.0 * TOGAF 8
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JasperReport - error with conditional parameter in SQL
 
Similar Threads
Implementing auto increment programitcally
Parameters passing doubt in Jasper reports
difficulty in login in one attempt
iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)
Mapping BigInteger java object into a ResultSet Data Type