Please explain exactly what is off when you run this report so we can get a better feel for what is going wrong? Using IIF() in Report Variables is something I do all the time so the concept you are using should work.
Cathy
>Hi All,
>
>I have a small problem with a trial balance report, I have 2 sides debit and credit for each account and I do group them in the report and sum the debit side and credit side also I need to put in a variable of the debit blance the deff. between debit-credit which is greater than 0 and in the credit balance the values less than 0 then in the group footer I need sum each one of them to get the totals, I'm trying to use the report variables one of them with condition of IIF(debit-credit>0,balancedebit,0) and the other IIF(debit-credit<0,balancecredit,0) then I need to sum them in the end of the report by normal sum in the field, I tried but no success, any idea about this subject in reports ???? urgent help needed
>
>
>thanks
>
>Hisham