Syntax for Filter expression with "In" Operator

[Shweta]

I am working on Telerik Report and i want to add filtering on report parameter. I have two multi value dropdowns. When multiple values from one box is selected data in other multi value box is  filtered. I am having issue with FilterOperator.In as not getting how to pass multiple comma seperated values to it. Below is my code:
 var calendarPara = new ReportParameter(FacilityScheduleParameter.Calendar, ReportParameterType.String, null);
            calendarPara.Visible = true;
            calendarPara.AvailableValues.DataSource = calendarList;
            calendarPara.AvailableValues.DisplayMember = "=Fields.CalendarName";
            calendarPara.AvailableValues.ValueMember = "=Fields.ID";
            //calendarPara.AvailableValues.Filters.Add("=Fields.BookingType=Parameters.Event OR Parameters.Event='" + GetDataSourceSql.AllValue + "' OR Fields.BookingType='" + GetDataSourceSql.AllValue + "'",
            //            Telerik.Reporting.FilterOperator.Equal, "=True");

            calendarPara.AvailableValues.Filters.Add("=Fields.Category", Telerik.Reporting.FilterOperator.In, " ='Acat','11111','Xyz' ");


Filter is not working, i am not getting correct syntax.
Please help as stuck in it and have very important delivery to wind up

[Stef]

Hi Shweta,

Please check my post in the Can't seem to get Filter expression to work when Case Sensitive forum thread.

If you need further help, let us continue the discussion in one of both threads in order to keep a better track on the exchanged information.

Thank you for your understanding.

Regards,
Stef
Telerik