I believe that the easiest way is to get the SUm before calling the report, store SUM in the variable and use it in the report later.

>I have a report that performs a calculation in the summary band. The calculation is sum(max_credit) - sum(sales_amt). There is a one to many relationship between Max_Credit and Sales_Amt. Max_Credit is at the Customer level and the Sales_Amt is at a lower level. Meaning that a straight sum(Sales_Amt) will work but I only want to sum the Max_Credit when the Name changes - for each unique name.
>
>How is this accomplished?
>
>Name,Max_Credit, Sale_Amt
>smith,1000.00,50.00
>smith,1000.00,75.00
>johnson,2000.00,35.00
>taylor,500.00,25.00
>taylor,500.00,55.00