Syntax for Filter expression with "In" Operator

2 posts, 0 answers
  1. Shweta
    Shweta avatar
    3 posts
    Member since:
    Mar 2016

    Posted 02 Mar Link to this post

    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
  2. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 03 Mar Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
Back to Top