I an using RadChart to show simple counts in chart form. The data is stored in SQL Server 2008, and I'm looking for the most efficient means of populating counts using RIA Services to access the data. Because of the large number of records, I would prefer that the counts be calculated on the server. For example, I would like to retrieve the number of product orders for each month in the past 12 months, then use RadChart to chart the total count for each of the 12 months. There could be 1000's of orders per month. Any recommendation?