Skip to Content
avatar image
Former Member

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



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 06, 2008 at 07:33 AM

    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



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.