Radgrid Sorting along with Grouping?

[Saad]

I have made a dataTableAdapter and defined it as a source for my radGrid. Everything is fine, I am getting all columns from my table but have changed datetime format using DATEADD(dd, 0, DATEDIFF(dd, 0, DateTime)).  Now i just need to sort all my records in descending order (thats it latest ones first). So I have tried sorting it in my query using Order By clause and through sortExpressions in radGrid as well. But its not working...please help me!

NOW I HAVE FOUND THAT WHEN I AM USING GroupByExpressions, my sorting doesnt take place. Otherwise it sorts my records....

[Iana Tsolova]

Hello saadi,

Which field are you using in order by clause or grid sorting expressions? Is it the original date field there or the formatted one? I suggest that you use the original field in this case.

If you could send us a sample project illustrating the described behavior can help us get to the source of the issue and find a resolution.

Additionally, you can review the below topics for more information about grid sorting and grouping:
http://www.telerik.com/help/aspnet-ajax/grdbasicsorting.html
http://www.telerik.com/help/aspnet-ajax/grdsortingexpressions.html

Looking forward your reply,
Iana
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.