I cannot get my totals to work in my SSRS 2005 report in my table footer. Check out below, they are inflated

Should I be using a Matrix or something or am I missing something here...it's driving me nuts!

Here is a picture of my report to help: http://www.photopizzaz.biz/reportserver_grouping_p.jpg

A screen shot here on another column in the same report showing overinflated total in footer:

http://www.photopizzaz.biz/reportser...ping_prob2.jpg

http://www.photopizzaz.biz/reportser...ing_prob2b.jpg

This can't be that hard, what am I doing wrong!!!

totals are accurate...I just needed to add SUM() to my group row fields and then I saw the light...My grand total was acting fine, it was just my row items that weren't showing currect Sums. I assumed that since the SSRS 2005 report had a group, that it would sum up it's rows automatically but that's not the case, you still need to use SUM() around your fields in your group.