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