Once upon a time, there was SPGridView

About SPGridView Filtering and Grouping check out this posts:

http://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx

http://blogs.msdn.com/powlo/archive/2007/05/15/using-spgridview-filter-properties.aspx

And did you knew that SPGridView had a bug?

http://blogs.msdn.com/valdon/archive/2009/03/11/how-to-work-around-bugs-in-the-spgridview-control.aspx

(this for my own future reference since i wasted more than 5min looking for this pages...hope it helps you)