The proper method to build group by expressions for RadGrid for ASP.NET AJAX is demonstrated in these online resources:
Note that you need to specify at least one select field and one group by field for the newly created expression in order to be evaluated properly.
Additionally, you can test whether the manually created SELECT ... GROUP BY
query is executed successfully by the SPDataSource when using regular MS GridView instance.
the Telerik team