Pass multiple filter values to a detail report (master-detail using sub reports)

[smith spd]

Hello Telerik Team,

I have a requirement where in i need to pass multiple  filter values to a report.I am using master detail reports using Subreports .
But as of now..i am  able to provide only single filter to the detail report.

 Telerik.Reporting.Data.Filter fltrVal = new Telerik.Reporting.Data.Filter();
            fltrVal.Expression = "=Fields.ItemID";
            fltrVal.Operator = Telerik.Reporting.Data.FilterOperator.Equal;
            fltrVal.Value = "=1000";
            this.Filters.Add(fltrVal);

How do i pass multiple values to this filter.I have an array of values to be passed.

I appreciate your help. and support.

Thank you
Smith

[Peter]

Hello Smith,

We don't have out of the box solution for your requirement but you have two options:

• create a new filter for every value 
• use the OR keyword in the expression for every value as shown in the following code snippet:

Telerik.Reporting.Data.Filter fltrVal = new Telerik.Reporting.Data.Filter();
fltrVal.Expression = "=Fields.ItemID=1000 OR Fields.ItemID = 50000";
fltrVal.Operator = Telerik.Reporting.Data.FilterOperator.Equal;
fltrVal.Value = "=True";
this.Filters.Add(fltrVal);

Best wishes,
Peter
the Telerik team

[smith spd]

Hello Telerik Team,

Thank you for the response.I will try the method proposed by you.

Thank you for the support.

Smith

[Lance]

What about the FilterOperator "In"?  I see it available in the filter screen, but I get an error when I try to use it (the combobox for the Value column can be initialized), and I can't find any documentation on how to use it.  Any pointers?

[Peter]

Hello Lance,

This is a known issue that slipped into the Q3 2010 release and has been fixed immediately in an internal build available for download in your account.

Please upgrade and let us know how it goes.

Best wishes,
Peter
the Telerik team