=iif(Fields!Executor.Value = "1", "ok", "pusto")

declare @t table (Executor varchar( 500 ))

/* Здесь по полной программе: есть и Home и otel и villa */
insert @t 
 select 'otel' union all select 'flat' union all select 'villa' union all select 'Home' union all select 'otel' union all select 'tower'

select * from @t

-- Проверяем, сколько всего в наличии
;with cte (ex) as
(
 select 'home' union all select 'otel' union all select 'villa'
)
select distinct cte.ex, count(t.Executor) over (partition by t.Executor) [cnt]
from cte
left join
(select Executor from @t) t
on cte.ex = t.executor

/* Уберем отели */
delete from @t where executor = 'otel'

-- Опять проверяем тем же запросом.
;with cte (ex) as
(
 select 'home' union all select 'otel' union all select 'villa'
)
select distinct cte.ex, count(t.Executor) over (partition by t.Executor) [cnt]
from cte
left join
(select Executor from @t) t
on cte.ex = t.executor

/* Уберем Home, otel, villa */
delete from @t where executor in ('home', 'otel', 'villa')

-- Тот же проверочный запрос
;with cte (ex) as
(
 select 'home' union all select 'otel' union all select 'villa'
)
select distinct cte.ex, count(t.Executor) over (partition by t.Executor) [cnt]
from cte
left join
(select Executor from @t) t
on cte.ex = t.executor

=iif((Fields!Executor.Value = "home" and Fields!cnt.Value >  0 ), false, true)