Expand/Contract dynamic table to display detail
Posted on 2006-10-19
Hello - here's what I'm trying to accomplish...I have a table in an asp page that displays the results of a dynamic recordset. The data is grouped in an sql statement by a destination like so...
"select acctnum, destination, count(widgets), sum(dohickeys) from tableXYZ group by accntum, destination"
I would like to have another recordset the same as above but that includes an origin to the detail, like so...
"select acctnum, origin, destination, count(widgets), sum(dohickeys) from tableXYZ group by accntum, destination"
I would then like the ability to expand/contract the results of the first recordset in the table and display the detail from the second recordset, like so...
acctnum destination widgets dohickeys
+ 1234 ATL 2 5
- 2347 BOS 3 7
origin destination widgets dohickeys
CLE BOS 2 2
PHL BOS 1 5
and so on...