Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Repetition of field values in Crystal Report

Hi Experts

I am using SAP B1 and crystal report2008.

I am trying generate a report in Crystal report.

I made link between tables OCRD,OINV and ORCT by Cardcode and Card name.

I designed report like

Card Name Opening Balance OINV.Doc Toatl ORCT.DocToatl

The issue is,

When I generate the report it gives repetition of values

Eg. XYZ customer has 5 invoice totals 3 payment transaction

it displays 5 invoice totals correctly but in payment column it repets the existing value to match the invoice total rows. It means, ORCT.Doc Total has only 3 transaction but it show 5 rows with existing values again.

Requesting solution solve this problem



Former Member
Not what you were looking for? View more on this topic or Ask a question