Basically, when you add second band, report writer doubles number of 'processed' records so your total certainly goes astray (could be twice more).

>I could, I guess. But I am trying to figure out what I am doing wrong with a multi-band report. If I don't learn now, I will make a mistake again and again.
>
>>Can you just use Grouping with PO header in Header band?
>>
>>>The Band1 is the P.O. Header and Band2 is P.O. Items. So the report shows one line for the P.O. header info (Vendor, Dates, Total Amount) and then a bunch of items. Then at the bottom it is supposed to summarize the P.O. Amount column. Am I more clear now?
>>>
>>>Thank you.
>>>
>>>>I'm confused on what you are trying to explain. By Band1 and Band2, are you referring to Detail1 Band and Detail2 Band (as in a multiple detail band report) .. or are you referring to some header band and just one detail band?
>>>>
>>>>Please be more specific and list exactly what expression and settings you have in the variables and what expression and settings you have in the objects you are printing.
>>>>
>>>>Cathy
>>>>
>>>>
>>>>>I can't figure out why my Total number on a report is completely off the mark.
>>>>>
>>>>>The report has two bands. The total of a column of band1 is a variable that is supposed to SUM a value of a field. The field name is unique to the Band1 (header of the report). Band2 shows detailed items and no totals. But the Sum Total variable prints a much higher number. The "Variable to Store" on the Variables tab of the report designer shows the field name without the alias.
>>>>>
>>>>>I have the same report without the second band (details) and that one works.
>>>>>
>>>>>What am I missing?
>>>>>
>>>>>Thank you.