| In an expression, testing if a type date parameter is null is not working [message #248228] |
Mon, 16 July 2007 17:52  |
Eclipse User |
|
|
|
Hi,
I have the result of a query in a table of 2 columns:
- connection_number
- connection_date
The connection date column is type Date (format yyyy/M/d)
I have a report parameter of type Date (called myDate) with the format
yyyy/M/d
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.03334 seconds
Home