Tricky question! I chose B. You may find the information here useful:  http://technet.microsoft.com/en-us/library/ms174909.aspx

------------ info below is copied from url ----------------

When you select All departments as the Department parameter in reporting services report you will wind up with a string containing all the departments delimited by commas like "Accounting, Management,...

You may want to look into using SSAS and Excel combo for ad hoc analysis of data. Excel is a great ad hoc analysis tool for viewing cubes built in...

Just pass the concatenated string into the stored proc and then use the methods in my previous post. When you select multiple parameters in reporting services the parameter value contains...

If you are using the multiple selections in an mdx query then use the STRTOSET function. If you are using in a sql query and the value field of the...