Win a copy of Practical SVG this week in the HTML/CSS/JavaScript 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!

 
He's dead Jim. Grab his tricorder. I'll get his wallet and this tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!