title: Is it better to group by data at server or at client?
body: <p>I am developing an app using c# and sql server 2008 to automate a sport club, and i almost done.
  Now i am making reports for my app by creating stored procedure in sql server that returns the data fro c# app after passing some parameters, and the result of report like grouping, number of fields returned are changed depending on the sent parameters.
  My question is better to do the grouping in sql server and return the last result and show it in c# report or get the data without grouping or sorting and do it in c# report you know in c# reports you can make groups and chose what fields to group by</p>
  
  <p>Thanks in advance.</p>