Hi @iskala venkat ,
Your issue seems to be similar to the one in this link:https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ef341204-0591-4383-b407-dffd8996405e/any-way-to-pass-multiple-values-for-a-single-label-in-the-parameter?forum=sqlreportingservices
In your case, when there are two values in one of your Labels: "0, 1". If your parameter is setup as above you will quote it in the where clause of the dataset query like so:
WHERE Column1 IN (@Area)
From the dataset properties, go to the parameters tab, click expression editor next to the value column for your parameter and set it to:
=Split(Parameters!Area.Value,",")
This will take the raw value from your parameter and convert it to an array, just like a multivalue parameter passes for its values. So the WHERE clause will cause the dataset to return data where Column1 is either “0”, or “1”.
Best Regards,
Joy
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.