|In an expression, testing if a type date parameter is null is not working [message #248228]
||Mon, 16 July 2007 21:52
| Nicolas Thuillier
Registered: July 2009
I have the result of a query in a table of 2 columns:
The connection date column is type Date (format yyyy/M/d)
I have a report parameter of type Date (called myDate) with the format
and as default value: null value
What I want is to apply a filter to my table:
If the report parameter myDate is empty then display all the entry
Else only display the entry whose the connection date corresponds to the
date entered in the MyDate parameter
In the filter panel, I try the following expression:
(params["myDate"] == null || row["connection_date"] == params["myDate"])
operator Is True
But the expression is not working.
If I try the following filter:
row["connection_date"] == params["myDate"] is True, it is working
but if I try:
params["myDate"] == null is true, it is not working.
If I try
expression: params["myDate"] and operator: Is Null, it is working.
But I cannot separate the expression in 2 filters expression. I want an
"OR" filter and filters working as "AND".
It seems params["myDate"] == null is not working in an expression.
Do someone know how I can test if a report parameter of type date is null?
Or How I can do to apply the filter I want?
Thanking you in advanced for your help.
Powered by FUDForum
. Page generated in 0.09115 seconds