>>I have a report and have the same field (balance) across the detail band but with "print when" expressions to determine which column it should print on. Everything in the detail band works fine but the totals in the page footer are printing the SUM of the balance field in all columns,instead of respecting the "print when" expressions in the detail band.
>>
>>How can I get the totals to reflect the SUM of each individual column including the "print when" statements?
>
>If MyCondition is the condition in the Print When box, then your total field expression should be :
>
>Detail Field * IIF(MyCondition,1,0)
>
>The Print When expression is evaluated for every record in the detail band, but not in the page footer.
>
>Hoping this helps

It really does help, and now I can see the order of events during a report. Specifically, how the totals are calculated during each record, and how an IIF statement such as the one you gave me would work perfectly in this situation.

Thanks for your help,

Steve