Hi,

I am having same issue. Can you let me know details of what you modified in SSRS report and in SQL query so that the null value is handled.

My problem is that, if null is selected as a check box in report, the SQL query should pull all null values

e.g

Original query:

select a, b,c from xx where id =@id (select a,b,c from xx where id = 2)

if null value is passed it becomes: select a,b,c from xx where id = null which is wrong. Rather it should become where id is null

Thanks a lot!