Home Forums Reporting Services Reporting Services 2005 Development NO Filters in DataSet if Variable is Null RE: NO Filters in DataSet if Variable is Null

  • February 25, 2014 at 7:53 am

    #1691895

    RamSteve (2/11/2014)

    Hi I have a Dataset In SSRS Report and I added Filters with my condiation as = @Variable .

    I am getting the results as expected for my condition . If my variable is NULL i need to retrive all my rows with out filter

    You could do something like:

    WHERE condition = COALESCE(@Variable, condition)

    That way, if the variable is Null, in essence you're saying 1 = 1, which is always true.

    HTH,

    Rob