Zaheer,

I always run a SQL select to create a single flat cursor that has the columns of both tables that are needed for the report. Report banding can be used to create the appearance of the parent-child relationship.

>I have two tables in report data environment. The relationship between them is a field named section and the same field is data group. All the calculations are ok expect the sum of parent table's fields in summry. When I interchange parent to child and child to parent it always give worng sum of parent table's fields only in summary band. I tried using variables and by changing data grouping but still the problem is same. When I use single table report it gives all the sum correct. The problem is due to two tables and the child table has all the calculation ok. All the calculations are ok even in group footer. Only in report summary parent table fields give wrong sum.