Hi, Iam working in SSRS 2008 R2, I have 8 matrices on the report ,based on the parameter selection my matrices have to display. My parameter is Muliple values. so if two or more selection made,accordingly matrices should be displayed. i used switch condition in the visibility but it does not work for multiple combination, here is my expression =switch (join(Parameters!DATA_TO_CHAIRMAN.Label,",")="Details of Sanctions",false, join(Parameters!DATA_TO_CHAIRMAN.Label,",")="Details of Sanctions,Details of Disbursements",false, join(Parameters!DATA_TO_CHAIRMAN.Label,",")="Details of Sanctions,Details of Disbursements,Details of Weighted Average Yield on Disbursements",false, join(Parameters!DATA_TO_CHAIRMAN.Label,",")="Details of Sanctions,Details of Disbursements,Details of Weighted Average Yield on Disbursements,Details of Portfolio",false, join(Parameters!DATA_TO_CHAIRMAN.Label,",")<>"Details of Sanctions",true, join(Parameters!DATA_TO_CHAIRMAN.Label,",")<>"Details of Sanctions,Details of Disbursements",true, join(Parameters!DATA_TO_CHAIRMAN.Label,",")<>"Details of Sanctions,Details of Disbursements,Details of Weighted Average Yield on Disbursements",true, join(Parameters!DATA_TO_CHAIRMAN.Label,",")<>"Details of Sanctions,Details of Disbursements,Details of Weighted Average Yield on Disbursements,Details of Portfolio",true, ) kindly suggest any solution Regards RamyaMark this as answer if this post helps you.

It works fine using the following expression =IIf(InStr(Join(Parameters!DATA_TO_CHAIRMAN.Label,","),"Details of Sanctions"),False,True)Mark this as answer if this post helps you.

It works fine using the following expression =IIf(InStr(Join(Parameters!DATA_TO_CHAIRMAN.Label,","),"Details of Sanctions"),False,True)Mark this as answer if this post helps you.

The following thread is on "switch": http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/be29e6b0-6d22-4e82-a2f8-d4c55aeb8cf3 Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM