I have a report where the order header and detail have relation. The report is grouped on orderno. The detail band has alias orderdtl. The report at the end has totals for fields from orderdtl and orderhdr table. The totals for table orderdtl are correct but the totals of orderhdr are multiplied by the numer of records in that order.

Rajesh