Skip to Content
avatar image
Former Member

Crystal Reports 2016 Duplicate Lines

I have no idea what i am doing wrong trying to create a simple report with address and meter number and endpoint id. If i have just the address i get the 125 lines i expect but when i add meter number it duplicates the address for every meter number in the data there is only one meter per address. I just don't get it have looked everywhere online for a couple days now. See a lot of people with simlar issues but just not finding a solution that works

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 09, 2017 at 03:51 PM

    Hi Shane,

    Without looking at the database tables it's difficult to know what could be causing this.

    From your description, it looks like Meter and Address are in separate tables. Could you open the Database Expert and make sure the Joins between these tables is set up correctly?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded