SSRS drop down list displays no data -

i have ssrs report drop down list active,inactive , all. when select active , inactive displays data when select 'all' displays no data. have tried many possibilities did not worked me.

here condition in main procedure

where       ( (@status = 'all') or      (disableddate null , @status = 'active') or       (disableddate not null , @status = 'inactive')       ) 

and parameter query is

select 'all' status union  select distinct  (case when disableddate null 'active' else 'inactive' end) status            table 

change your,

parameter query to:

select 'all' status union  select 'active' status union  select 'inactive' status 

where condition in main procedure to:

where @status =  coalesce( case when status = 'all' 'all' end, case when status = 'active' 'active' end case when status = 'inactive' 'inactive' end )