• Post Reply Bookmark Topic Watch Topic
  • New Topic

JasperReport - error with conditional parameter in SQL  RSS feed

 
Chengwei Lee
Ranch Hand
Posts: 884
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!

 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!