Skip to Content
0

Crystal Reports 2016 Duplicate Lines

Aug 09, 2017 at 02:48 PM

33

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Aug 09, 2017 at 03:51 PM
1

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
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

0
Former Member

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

0