report control Subtotal

Hi,

Hi,

Hi,

Unfortunately, I don't believe there is any automatic way to create a sub-total row like what you are looking for.  You will need to loop through the rows and use variables to tally up the total.  At the appropriate spot during your loop through the rows, you will need to manually insert a sub-total row.  I actually do this in one of my programs but it requires a lot of code.  If I remember correctly, I actually create a linked list in memory and "build" the table with the sub-total rows using the linked list.  Once the linked list is complete, I use it to build the table.

One thing that can cause problems is if the sort changes on the table.  The only way to solve this is to rebuild the sub-total rows if the sort changes or do what I did and disable sort on the table.