Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JasperReport - error with conditional parameter in SQL

 
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!

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic