fraogongi 0 Newbie Poster

Hi!
I have a web application in ASP.net 2.0. within it i want to corporate a report that will list all the customers together with the products they have bought in a sub group. Thereafter i need to find the subtotals of all th ecustomers within the same reports.

The problem is that i dont know how to get the subgroups. Am retrieving the data from a database (SQL server 2005).

Can anyone help me with generating the subgroups? Thanks in advance.