how can i get the same feature as the raddatafilter in the silverlight for my report

[Tai]

Hi

after reading some threads , i know that we can't use the raddatafilter for the reporting or we don't have any similar components like that in the reporting.

However, how can i get that similar function of the raddatafilter for my reporting

For example, if my radgridview has 3 columns (last name, first name, age)

then i want to be able to filter by Last Name or First name or age ( a drop down box for them will be the best solution). I don't want to have seperated box for each of them (in my real case, i will have a lot of field for the table)

then another drop down to let the user choose the "operator"
and another field to let the user type the value

a function which is similar to the raddatafilter

In summary, i want to achieve something which can let me filter all of the possible Field names in my table without having separated component for each fields. And then let the user print it (having preview option )

I hope my explanation is clear enough

thank you 

[Steve]

Hi Tai,

There is no interactive filtering built-in into the report itself. However you can filter your report by using the Report Parameters. If needed you can create the filter expression directly in your calling application by user input from UI you've created, but cannot control the report filtering with the Filter asp.net control. See the following links for more information:

• Filtering Data
• How-To: Add filtering to Report
• How-To: Add filtering to Table item and Crosstab item

Greetings,
Steve
the Telerik team

[Tai]

Hi

if possible, can you do a sample demon for your post
"If needed you can create the filter expression directly in your calling application by user input from UI you've created"


thank you

[Steve]

Hi Tai,

Here is a sample code snippet:

(this.ReportViewer1.Report as Report1).Filters.AddRange(new Telerik.Reporting.Data.Filter[] { new Telerik.Reporting.Data.Filter("=Fields.MyField", (Telerik.Reporting.Data.FilterOperator)Telerik.Reporting.Data.FilterOperator.Equal, "=Parameters.MyParam") });

As you can see the report object is exposed and available for use directly from your calling application.

Kind regards,
Steve
the Telerik team

[Alessandro Parini]

Hi,
Can I create a filter expression like "condition1 OR condition2"?

Thanks

[Peter]

Hi Alessandro Parini,

The OR logical operator is supported in the expressions. For more information check out Operators help article.

Regards,
Peter
the Telerik team