Crystal Report Issue - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

dipu

Basic Member

Posts: 9

4/22/2010 10:02 AM

I have created a crystal report with two oledb commands. After refreshing the report lot of duplicate data is coming. How can I remove those duplicate data from the report? please help.When used these commands in seperate reports I got correct data without duplicates. The join I have taken is left outer join.

mark.cook

Veteran Member

Posts: 444

New Poster

4/22/2010 10:58 AM

It sounds like a join issue. Can you provide a little more detail as to the tables you are using and what is being duplicated.

Matthew Nye

Veteran Member

Posts: 514

4/23/2010 6:12 AM

This is the real downfall of the OLE DB provider for Lawson. The relationships are very shallow. The reason youre getting duplicates is probably because an Employee can have multiple positions, some active some inactive. Be sure you are at least identifying the active positions (if this is an accurate portrayal of the data). To give better assistance it would help to see the full query code. Also the version of Lawson application you are running is vital information as schema are deferent between 8.x and 9.x.