Jump to content

Relative dates in jrxml controlling null values


Recommended Posts

Hi there


Recently I've been trying to implement this option in my report in order to schedule it. 



However when I try to control null values in my date column, the report seems not to work correctly given that actually I am getting registers with this value in null.


I have tested this option in the $X expression but it does not work:


WHERE $X{LESS; COALESCE(column_date,'2100-01-01'); date_parameter} 


Is there anything else that I could try?



Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic


i don't think you can use the SQL functions in the $X{} clause. It's $X{Function; Field_name; Parameter_name}. Field_name needs to be something identifyable for the compiler, it can't identify the functions. The $X{} clause is made to avoid the specifics of certain database engines about how they require different operations to be coded. Adding extra functions there removes the whole purpose of this.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...