Crystal Reports 2016 Duplicate Lines

[Former Member]

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

[abhilash_kumar]

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

[Former Member]

I think that may be where my issue is. They are sepearate tables and not sure i understand how to join them properly

[Former Member]

Here is a screen shot of the links maybe this will help