crystal-reportssapb1

Item is duplicating because of a text line in crystal reports

Item is duplicating because of a text line in crystal reports. If i remove the details section for the text lines, the items details dont duplicate. How many I resolve this. enter image description here

enter image description here

Below is the structure of the crystal report enter image description here

Another example of an invoice where they are 2 different items. Doesn't duplicate on the 2nd item just the first one. enter image description here enter image description here

Solution

  • NUPK309 has 2 text items so it gets duplicated 2 times.

    NUPK311 has no text items, so it doesn't get duplicated.

    If you look at the report joins, it's probably an outer join from the item to the text items. That is fine. But you need to decide how you want to handle multiple text items per a single item. Consider one of the 3 solutions suggested above.