Subtotal Line

[char]

I am trying to get subtotals by date to appear after all items for that date have been completed..for example

07/29/2007 SHOES 225
07/29/2007 BOXES 350
07/18/2007 SOCKS 2500
07/08/2007 LACES 500

right now I am getting the total at the bottom of my asp page

07/29/2007 575
07/18/2007 2500
07/08/2007 500

instead of after each date completion
07/29/2007 SHOES 225
07/29/2007 BOXES 350
TOTAL: 575
07/18/2007 SOCKS 2500
TOTAL: 2500
07/08/2007 LACES 500
TOTAL: 500

Can someone point me in the right direction?

[jhardman]

Show your code. How are you making the totals now?

Jared

[char]

MySQL = "SELECT * FROM ReportSummary (NOLOCK)"
MyRecordSet.OPEN MySQL, XXXXX
MyArray = MyRecordSet.GETROWS()
MyRecordSet.CLOSE
FOR MyCursor = LBOUND(MyArray,2) TO UBOUND(MyArray,2)
body = body + "<TR><TD BGCOLOR=""" & SHADE & """><B>" & "&nbsp;</TD><TD BGCOLOR=""" & SHADE & """><B>" & "</TD><TD BGCOLOR=""" & SHADE & """><B>" & "&nbsp;</TD><TD COLSPAN=4 BGCOLOR=""" & SHADE & """><B>"& MyArray(0,MyCursor) & "</TD><TD ALIGN=""CENTER"" BGCOLOR=""" & SHADE & """><B>" & MyArray(1,MyCursor) & "</TD><TD ALIGN=""CENTER"" BGCOLOR=""" & SHADE & """><B>" & MyArray(2,MyCursor) & "</TD><TD ALIGN=""CENTER"" BGCOLOR=""" & SHADE & """><B>" & MyArray(3,MyCursor) & "</TD><TD ALIGN=""CENTER"" BGCOLOR=""" & SHADE & """><B>" & MyArray(4,MyCursor) & "</TD><TD BGCOLOR=""" & SHADE & """>"& "</TD><TD ALIGN=""CENTER"" BGCOLOR=""" & SHADE & """></TD></TR>" & vbcrlf
IF SHADE = "#FFFFFF" THEN SHADE = "#DDDDDD" ELSE SHADE = "#FFFFFF"

My totals are coming up at the end of the asp page instead of after each date.

[jhardman]

hmm. This doesn't look like it has the code that calculates the totals. Is that just being calculated in the db?

Jared

[char]

Yes, it is calculated in the db. I am very new at creating asp classic and this was given to me without any training. I appreciate your help.

[jhardman]

The thing is your ASP script just opens up the report and prints it out with a little formatting (gives alternating colors for each row). If you want to do this the same way (without re-writing the script) you would just need to go into the db manager and edit how the report is made there.

On the other hand, I usually make the report in the script, so I like to open up the raw data and add up all the totals in the ASP page. I guess what I am trying to say is you have the choice and you should choose based on which you feel more comfortable messing with. Does that make sense?

Jared

[char]

Yes...thank you for all your help.