Good to know, thanks.

>You can do a slight twist to this solution. Create one variable, rnTotal, set the value to 0, set it to SUM, reset at end of report.
>
>Next, in the OnExit expression of the data group, use this:
>_VFP.SetVar('rnTotal',rnTotal + [the variable holding the sum] )
>
>
>
>>Brenda,
>>
>>Create a group in the report (if it is not yet there) based on the field in relation. Add two report variables:
>>- var1 having initial value 0, value to store 1, calculate COUNT, reset on the group
>>- var2 having initial value 0, value to store iif(var1=1,amount,0), calculate SUM, reset on the report end.
>>
>>Var2 should give you the total for the parent table.
>>
>>>The table is already selected and contains all the data that I can use. I am only allowed to make my changes in the report designer. I am helping a client who uses third party software to create the table and takes me right to the report designer.
>>>
>>>Brenda
>>>>You do not need to change anything in the table:
>>>>
>>>>use (yourtable)
>>>>sum (field_name) to variable_name