Rank: Advanced Member
Groups: Member
Joined: 8/26/2009
Posts: 64
|
I need a grid with filter capabilities. In Excel this is called AutoFilter. In Access, it's called "DataSheets".
In Excel/Access, user can click on column header and see all the available values in the row OR they may put in a specific filter value and comparison operator.
In EO, the way I was planning to do this was add a one row grid above the grid that contains my data.
This one-row grid would custom columns, each with a listbox template so the user could select one or more values that should be used to filter the grid below. I am not sure yet how I would handle the filter values and operator, but probably a context menu with a dialog of some sort.
This is going to be a lot of work, but well worth it. Nobody has a web-based datasheet out there as far as I know -- one thing that keeps a lot of good applications off the web, unfortunately.
Before I launch into this -- do you think I am taking the best approach or do you have another suggestion?
|
Rank: Administration
Groups: Administration
Joined: 5/27/2007
Posts: 24,194
|
Hi,
Yes. I think the way you are doing it is the most felxibile approach. You will need to use a CallbackPanel/UpdatePanel to update the bottom grid though. Basically once you select a filter, the whole grid is reloaded with filtered data.
Thanks!
|