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

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

Actions