I ran a report a few weeks back and the report was exactly the way it was supposed to work, (a rare occurrence).
I was asked to add a currency field into the report. Now when I run the report, I am now getting duplicate records on the first two listings of each record. Here is an example:
This is the original report:
Field1 Field2 Field3
AAAA 0001 1111
BBBB 0001 2222
CCCC 0002 3333
Then I added the currency field:
Field1 Field2 Field3 Currency
AAAA 0001 1111 1.00
AAAA 0001 1111 1.00
AAAA 0001 1111 .80
AAAA 0001 1111 .65
BBBB 0001 2222 5.25
BBBB 0001 2222 5.25
CCCC 0002 3333 2.25
CCCC 0002 3333 2.25
CCCC 0002 3333 1.55
You get the idea. Every record has the first two listings duplicated. Has anyone else come across this problem? I'm sure I'm not the first.

Thanks in advanced,
Al