none
Report filtering null date values RRS feed

  • Question

  •  

    I have a report and I have a table that I need to filter null dates, I have the following configuration in the table:
    Filters
    expression    = Fields! GIR_Fecha_anul.Value
    Operator       ! =
    Value           =????

    I have a column of dates in a database sql server 2005 that has multiple records null, the report to make the rendering, these passes as a no data this mean " ".  I need to pass a " " value for the filter, but in the functions of report.rdlc I can not put the value = "" because it obviously tells me that I can not compare a string with a datetime,
     
    how do I tell to the report that the filter value of the report is " " and with this the records that do not have data be filtered.
     
    Thanks
    Monday, November 19, 2007 5:13 PM

Answers

  • In your SQL Statement try

    Code Block
    isNull(GIR_Fecha_anul,'') as GIR_Fecha_anul

     

     

    to have the statement return from sql the effect you want.

    Monday, November 19, 2007 9:35 PM

All replies