Custom subtotaling.

[Peager]

I have a G/L journal summary report that's giving me problems. The data set detail records are individual debits and credits against G/L account numbers. The 'detail' for the report is a grouping by account number where I 'net' the debits and credits into the appropriate column. i.e. the "Debit" cell in the subtotal line =IIF(Sum(Fields!debit.Value)>Sum(Fields!credit.Value),Sum(Fields!debit.Value-Fields!credit.Value) This works perfectly for my puposes.

The problem arises when I go to the next level of subtotal. I want to be able to total the values printed in the previous subtotal. All of the aggregate functions are based on the records in the data set, not in the previously printed values.

 

[RiverGuy]

Can you use a calculated field for your formula instead of typing the formula into the cell? Or is this outside of the actual details section?

 

[Peager]

No, this won't work in this case. I reworked the query to return sub-totaled data and got it to work that way. Thanks for the input.