Skip to Content
0
Former Member
Jul 05, 2008 at 06:28 AM

Table Relationship

32 Views

I am using Visual Studio 2005 (visual basic) with Business Object Crystal Report XI. I have a report that reads data from 2 tables, 1 header and 1 detail. I have problem defining the relationship of the 2 tables. The problem that I am facing now is with all the aggregate and count function. Say if my header table has 1 record, and the record has 3 records in the detail table, the COUNT({header.primarykey}) will return the value 3, and the SUM({header.somevalue}) will be 3 times the correct value.

I think this has arised because I defined the relationship wrongly. Should I point the detail table to the header table or vice versa?

Thank you.