Filter on textbox?

[Andreas Kaech]

Hi Telerik,
I have the following "challenge":
In a Crosstab I get the following Columns "r1, r2, r3, r4, r5, r6" with the Values "v1-v6". But I need only the Columns "r2, r3, r5" with their values. How can I filter this Columns out?
In other words: It exists "fields.first()" and "fields.last()". How I get a "fields.inbetween()"?

Thanks for answering,
Res

[Svetoslav]

Hello Res,

If I have understood correctly you have a dynamic column TableGroup that produces the r-columns. If this is the case there are several ways to filter the data for this column:

• Filter the data on the data source level before passing to the CrossTab. For example if the data comes from an SQL server and you know what exactly values you need to filter just add the corresponding WHERE clause to your query.
• Filter the data on the report level. Use the TableGroup.Filters collection to specify filtering expressions for this group. For more information please see Filtering Report Data. Depending on your needs you may consider using report parameters to let the user choose what values he/she wants to see or hardcode the filtering expressions. This demo illustrates the 1st approach where a Table item has a filter attached and this filter uses the IN-filter operator to filter the data according to the selected from the user values. If you find that the built-in expressions lack any functionality you need, you may always use your own (user) function to perform some calculations.

All the best,
Svetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.