Skip to Content
avatar image
Former Member

Crystal Report double journal entry

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!!

sap7.jpg (27.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 28, 2016 at 06:39 PM

    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"

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 28, 2016 at 06:50 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 31, 2016 at 09:43 AM

    Hi Nikka,

    Check your linking's otherwise use query instead of linking

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02, 2017 at 07:03 AM

    Hi Nikka,

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

    Regards,

    Zuber Kazi

    Add comment
    10|10000 characters needed characters exceeded