I meant to CC you on this. I think I forgot? Anyway here is my reply to Sergey.

Thanks again,

Hi Sergey and Cathy,

I've got it working now. I see now that I had two choices: 1)Use a calculated field in the subtotal band, and use the format property or 2)or use a report variable - and then use transform.. one or the other but not both. The problem as you've pointed out was that I was trying to use transform on a calculated field. I've since found a KB article that explains that this behavior is by design. I see now that the mistake I made was that I was trying to apply a sum on a report variable that was already summed, I was mixing up my report variables and calculated fields.

I am using Accountmate software and trying to adhere to their standards. They use transform and report variables in the subtotal band.. so I will stick with that for consistencies sake. (although it does seem to be more work to use a report variable and transform than just using a calculated field and the format property)

Thanks for your help!
David Schlesinger





>In the subtotal band, create the object and use the expression of nsubdamt (or whatever the name of the field is that you are trying to sum). Set the Calculate option to SUM. Set the Format/Picture to 999999 or whatever is big enough to hold the maximum size number.
>
>See if this solves the problem.