Details Section Repeating

[sprog]

Hi

I have created a little report with date paid, hrs paid and dollar value. For some reason each line of data is repeated 3 times before going onto the next date.

Can somebody tell me what has caused this and what I can do to stop it?

Thanks

 

[dgillz]

Do you have multiple tables in your report, and if so is there a many to one relationship between the tables?

I suspect that you do and the duplication oyu are seeing is a result of this. If this is the case, change your linking to a left outer join instead of an equal to join, and this behavior should stop.

If that does not work please post some details about the tables you are linking and how they relate to each other.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[sprog]

Thank you very much. That was my problem.