19. October 2007 06:22
Today I was having a terrible time with SQL reporting services default values for a multi-value parameter on my report.
I haven't been able to track down the root cause, but it seems a little tweaking to the query that selects the options will usually fix it.
For instance, try adding a rtrim or ltrim around the field when selected in the query.
select distinct option from options
select distinct rtrim(option) as option from options
This seems to help in most cases. If it doesn't, try performing a lower/upper on the string, or a replace on whitespaces.
I'll be interested to hear peoples feedback on this!