I have encountered a problem creating a report with two linked tables (left outer join).
I have a database with duties, associated with each duty is a couple of activties. As long as I leave the activties out of the report I can summarize information about the duties, but when I include any activity field in the report the summarized information about the duties multiplies.

I'll try to make a small example. I hope you can follow what I mean.

Example:

Before
------------------------------------------------------------
[Details]              duty 1                   duration 2.5 hours

[Report footer]  count duties =  1    sum duration = 2,5 hours

------------------------------------------------------------

After
------------------------------------------------------------
[GH 1]                  duty 1                     duration 2.5 hours
[Details]                          activity 1
                                   activity 2
                                   activity 3

[Report footer]  count duties =  4       sum duration = 10 hours
------------------------------------------------------------

Anyone who can help me sort this out?

/Ahlfri