1 Reply Latest reply: Nov 28, 2011 11:50 AM by Alun Davies RSS

duplicate data in crystal report getting from r/3

Rajesh B
Currently Being Moderated



I not sure if this is the correct place to post this


I try to create a simple stock overview report from R/3. I take table MAKT, MARD and MARA and the connection are


MARA inner join with MAKT

MARD left outer join with MARA


i make the report group by MARA.MATKL and i make the record selection as "{MARA.MATKL} in {?Material Group} and {MARA.MATNR} in {?Material}". The field i select is MARA.MATNR, MAKT.MAKTX, MARD.WERKS and MARD.LABST


The result i get for example RAW1 and RAW 2 with each record appear 3 times and in 1 of the record actually showing value in MARD.LABST. The report should


Can anyone please advice what i did wrong and how to correct it.