Multi-value Parameter Default Values Not Working

I have a parameter that gets it's available values from a dataset.



I use this exact same data to populate the default values.



When I run the report, the available values get populated; however the default values are not being selected.



This works on other parameters on the same report. However, on this parameter, it is not working.



I have tried ltrim/rtrim (Been burned with that before when the field type is a char)

I change the data field in the query, without changing the parameter setup, and it works...



Here is my query:




Code Snippet

Select distinct
CityName

from dimHotel dH (NOLOCK)
Inner join factHotel fH (NOLOCK)
on dh.HotelKey = fH.HotelKey

Where dH.CityName <> ''
and dH.CityName is not null
and fH.ClientKey in (@ClientID)

Order by CityName





The parameter is setup correctly, and matches the setup of another parameter on the same report that is working fine.



I have tried deleting the parameter and re-adding it. This did not work.

I also deleted and re-added the query. No luck.



Any ideas??

Thanks!!



Thanks