aspose file tools*
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 Spring in Action this week in the Spring 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