Crystal Report duplicating rows

[#1]

Hi,

I'm having an issue where a Crystal Report is duplicating rows despite the underlying query not showing the duplicates.

This seems to happen at random, at least I can't find any connection between instances. Today I have a query that returns 3 rows, but displays each row twice. Browsing any of the fields shows only the 3 rows. Running the query directly in SAP shows the same 3 rows.

Any suggestion where to look next?

[ido_millet · Accepted solution]

Check your table joins. Most likely, you are joining to a different table that might contain 2 matches, causing the record duplication.

If that was not the issue, then check section structure. You may have 2 details sections (Detail a and Detail b) with a section suppression condition that is supposed to cause one to show and one to suppress. But the logic is failing, causing both sections to show. If that is the issue, Crystal should show only 3 as the total row count (in the status bar).

[kevin_godfrey70347f · Accepted solution]

Thank you, I think this is where my problem lies. My HeaderData query is returning 2 rows, which is not correct.