wood burning stoves 2.0*
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
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: JasperReport - error with conditional parameter in SQL
 
Similar Threads
difficulty in login in one attempt
Mapping BigInteger java object into a ResultSet Data Type
Implementing auto increment programitcally
iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)
Parameters passing doubt in Jasper reports