display rows from a database in ASP

[jcook32]

I have a SQL statement that returns some data say 1000 rows. Each row has a Dept in common. Each dept has Groups within it. Say Dept1 has 3 Sub Groups. Each sub group may have any number of records for the question's sake lets say group one has 500 rows and Group 2 has 300 rows and group 3 has 200 rows. On my asp page I need to show 1 record for each subgroup and keep a running total of 4 other columns. I need all the numbers from each column added up for say group 1's 500 records.
this is an example of my table on my page:
Government Services Group 0 3356 2394 0 0 5750
Health Care Group 3125.1 0 0 0 0 6250.2
Intellectual Property Group 47918.4 0 0 0 0 95836.8
Department Total:


Please Help!!!!
If you want more points to answer this question please let me know and I will increase them

Thanks
jcook32

 

[IdoMillet]

Please clarify if/how this is related to Crystal Reports.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[jcook32]

this is in the wrong forum. It should be in a asp forum.