duplicate data in crystal report getting from r/3

[Former Member]

hi,

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.

Thanks

[Former Member]

you can fix the report at the CR end but I would sort it out at source.

what you need to do is understand why you get 3 rows