Skip to Content
Former Member
Oct 06, 2008 at 06:45 AM

Repetition of field values in Crystal Report


Hi Experts

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