Crystal Report double journal entry

[former_member236650]

Hi Experts!

I need help with fixing my crystal report. As seen below, the crystal reports generate double entries. How do I fix this? Thank you!!

[former_member324899]

Hi Nikka,

Please share SQL Query or table linking screenshot for better understanding.

Regards,

Zuber Kazi

[Former Member]

Hi Nikka,

Check your linking's otherwise use query instead of linking

[former_member199543]

Yes, check the table structure, the truth is there, or use free hand SQL instead!

[vitaly_izmaylov]

I would start with table linking - tables have to be linked properly. Unlinked tables generate duplicated records.

Then try to click Database at the top menu and "Select Distinct Records"