Relative dates in jrxml controlling null values

[db2907]

Hi there

 

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

 

https://community.jaspersoft.com/wiki/how-use-relative-dates-jrxml-static-reports

 

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?

 

Regards.

[Friendly User]

Hello,

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.