>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