rows repeated themselves in subreport CR10

Hello,

I have a subreport which is in the footer.

In the subreport i have put the fields in the details section.

However, there should be 5 rows printed out, but there is 15 as each row has repeated itself 3 times.

i.e.
a
a
a
b
b
b
c
c
c
etc

Should be just:
a
b
c
etc

I have checked the database table and that is correct there are 5 rows in there. So there must be something with the report.

Can anyone tell me, why this would be happening.

Many thanks for any help,

Steve

How many tables does your subreport use? More than 1?

Thanks for your reply,

The report just uses 1 report.

Steve