This is a migrated thread and some comments may be shown as answers.

Excel Style Filter With Multi Select?

8 Answers 121 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Adam
Top achievements
Rank 1
Adam asked on 19 Oct 2010, 09:02 PM
Hi,

We are currently implementing the grid control and like the various filter options but wanted to know if someone has achieved an Excel Style Multi Select filter, similar to how the new version of the Silverlight control works? Our problem is that from the column filter dropdown, we want to be able to select ALL or nothing or pick several items that are not in a range for example option 1,3 and 9.
The silverlight control looks like it would do the trick, is there something similar out there?
http://demos.telerik.com/silverlight/#GridView/FirstLook

Thanks in advance,
Adam

8 Answers, 1 is accepted

Sort by
0
Tsvetina
Telerik team
answered on 25 Oct 2010, 08:26 AM
Hello Adam,

The functionality which you describe is not supported out-of-the-box by RadGrid, so you would need to implement some custom logic. The two key points are replacing the built-in menu, which approach is described in this Code Library article and then manual handling of the FilterExpression of RadGrid.

Best wishes,
Tsvetina
the Telerik team
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 Public Issue Tracking system and vote to affect the priority of the items
0
brian
Top achievements
Rank 1
answered on 07 Dec 2011, 06:14 PM
We really need this filter option.  I'm surprised this is not an included option as having a row of textboxes or dropdowns below the Header text is not very UI friendly.   The excel way of filtering is the cleanest approach.    Has anyone done this code?  I need to implement this.
0
Tsvetina
Telerik team
answered on 07 Dec 2011, 06:23 PM
Hello Brian,

Have you considered using RadFilter to allow more flexible filtering for RadGrid? This way you will not need to perform the custom logic requred by the other approach:
Filter / RadGrid filtering with RadFilter

Kind regards,
Tsvetina
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now
0
brian
Top achievements
Rank 1
answered on 07 Dec 2011, 07:08 PM
That is very nice for advanced users.  Unfortunately, for non-advanced users they are familiar with excel filtering and it also does not add to the space the UI needs.   It's very clean for the UI.
0
Robert
Top achievements
Rank 1
answered on 23 Oct 2013, 04:30 PM
Brian,

What did you ever do about this?

Telerik is still using filter bars, if you can believe it. (in ASP.NET AJAX anyway).
0
brian
Top achievements
Rank 1
answered on 23 Oct 2013, 06:43 PM
In the Q3 2013 they have added Excel-like multi-check selections in the dropdown.   I have not implented it yet but pretty nice addition.   I believe it is still in the filter row though.   Progress!
0
Robert
Top achievements
Rank 1
answered on 23 Oct 2013, 06:46 PM
Brian,

Shouldn't we be able to add that to this:

http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/headercontextfiltermenu/defaultcs.aspx



take a look at the 'ship city' column,,,,imagine that being a dropdown arrow instead.

And, viola,,,if it works.
0
Eyup
Telerik team
answered on 28 Oct 2013, 12:43 PM
Hi Guys,

You can check out the following thread for possible approaches to achieve this requirement:
http://www.telerik.com/community/forums/aspnet-ajax/grid/handle-multi-selection-filtering-in-a-custom-column-class.aspx

Hope this helps.

Regards,
Eyup
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Tags
Grid
Asked by
Adam
Top achievements
Rank 1
Answers by
Tsvetina
Telerik team
brian
Top achievements
Rank 1
Robert
Top achievements
Rank 1
Eyup
Telerik team
Share this question
or