Report Builder not showing default value as select all

先看一下 query撈出來的資料是不是有 null或 blank""的值

如果有的話就會產生此情況

可以在 general勾選 allow blank value ("")來解決
或在 query裡先濾掉

where [field]<>'' or [field] is not null



reference:
My MDX SSRS report is not showing default value as 『Select All' (SSRS 2008R2)