Unfortunately it looks as though this is one of those things you just need to live with.

This post from MSDN should provide a little more insight ...

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/11cd657e-c767-4d37-b0c2-793c2afe38aa

I have also noticed...

Hi,

First of all I will point you to this article which discusses how mult-value parameters are handled by SSRS.

http://msmvps.com/blogs/robfarley/archive/2007/11/23/how-multi-value-query-parameters-in-ssrs-are-treated-by-sql-server.aspx

The main point from the article is that multi-value parameters...