Repetition of field values in Crystal Report

[Former Member]

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

BY

Kalai

[Former Member]

Morning D,

When you are counting ORCT.Doc Total, please choose the Distinct Count instead of only count. Distinct Count will choose distinct number of orders/docs and that should resolve your issue.

Please let us know how you get on with it.

Many thanks

Regards

Jehanzeb

[Former Member]

Hi

Thanks for reply.HI I tried the Distinct count It give correct nO. of Transactions But I didn't get Total transaction value.

As of now I didn't do any calculations in my report. I am just retrieving data's but it gives the above said problem.

Waiting for your valuable reply

By

Kalai

Edited by: D. Kalaiselvan on Oct 6, 2008 1:16 PM

Edited by: D. Kalaiselvan on Oct 6, 2008 1:19 PM

[Former Member]

Morning Kalai,

Could you please tell me how is your report setup? Are you using Crosstab? or manual report layout?

Many thanks

Regards

Jehanzeb

[Former Member]

Hi I am using manual report even I tried in Crosstab but it gives same type of report.

My report setup is

Table Links OCRD.Cardname->OINV.Cardname->ORCT.cardname.

Report fields(column wise)

CardName OINV.Doctotal ORCT.DocTotal

Give me a solution plz.