Hi All,

I have SSRS report. In that there is a date filter(Which is calendar). I want now if i dont select date it should give data for all the dates.

How to give this in expressions?

Thanks in advance.

You need to check AloowNull value for this parameter and give default value as Null.

Then in your bacckend query set condition as below

WHERE ( <your current date filter condition> OR @DateParameter IS NULL)

and it will work giving you details for all dates by default