Clever Geek Handbook

Reportviewer report filter - check date if Null

I am working in a c # windows application with vs2010 and a local database. In one of my forms, I am using ReporViewer to display a report.

I would like to be able to show the results from a record in this report only if a certain field (witch - date) is not null. I created a table and I added a filter, but it seems that the expression I am using is not correct.

I used something like this in Tablix Properties - Filters:

expression =IsNothing(Fields!payed.Value)

operator =

value =true

Any ideas? Thanks in advance! Maybe I forgot = in the input value. He is working now!

+3


source to share


2 answers


expression =IsNothing(Fields!payed.Value)

operator =



value = true

where payed is the date field

+4


source


Try the following

=IIF(IsNothing(Fields!payed.Value),"Show_your_desired_value",Fields!payed.Value)


the date field must be checked in the IsNothing () function. I am asking the question here, is the date variable being paid or not?

+2


source






More articles:


All Articles