>
>You must not have something right or I'm not understanding your problem. If you are trying to create a subtotal on a column in detail1 band .. define a report variable called rnTotal, set the expression to MyTable.AmountField, set the calculation option to SUM, set the Reset At value to Detail1Band. In the Detail1 Footer Band, print the rnTotal variable and it will contain the subtotal of the records that just printed in the last Detail1 band set. It should not contain just the amount of the last record in Detail1 band.
I thought I did do the steps exactly as you describe above. The only thing I have in addition is a Group By. So my total/sum variable is in the Group Footer. I didn't think this was making the difference but maybe it did.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
