Duplicate text in reports

[Akchayan]

Hello everyone,


I have this problem here:

but I want it to be displayed only once. Where could be the error?
Thanks for the help!

[Welshgasman]

You have multiple rduplicate ecords in the report source?
So adjust your query, perhaps with DISTINCT to just get the one record for each ?

Might want to start on Youtube with https://www.youtube.com/results?sear...ports+tutorial being a picture is meant to be worth a thousand words?

[Akchayan]

I mean that i just want the red area, i tried to adjust the query but i couldn't find the error.

[Minty]

Show us your reports query.

Or run the underlying query in design view of the report and you'll see the duplication I suspect.

[Welshgasman]

Should be pretty obvious?, duplicate records?
Computer programming has a very old saying. 'Garbage in, Garbage Out'

[Minty]

Possibly duplicates, but more likely a cartesian join or similar in the query.

[Welshgasman]

Possibly duplicates, but more likely a cartesian join or similar in the query.

I meant duplicates in the source, without any regard as to how they are created.
Cartesian would be a good bet I agree.

Only time will tell.

[Micron]

Post a pic of the query in design view, or let us know if there is more than one table in it and you have no lines joining 2 or more tables. If a Cartesian I'd expect to see at least one item change there but they all look the same to me. That being said, it could be that there are report fields that are not visible and that's where the duplication is coming from.