Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions  
Message Icon Topic: Duplicate Lines in Report Post Reply Post New Topic
Author Message
Frank in VA

Joined: 15 Nov 2007
Location: United States
Online Status: Offline
Posts: 38
Quote Frank in VA Replybullet Topic: Duplicate Lines in Report
    Posted: 14 Oct 2020 at 4:42am
Hi All,

I needed to modify an existing report by adding an indicator field and now I am receiving duplicate lines per customer.

I added a new table, linked it by customer number. I created a formula field to check the new table to see if a customer has an active policy. If so, I place a 'Y' in this new indicator field. The new table has multiple records per customer. Here's my formula:


Even though the formula is working, displaying the 'Y' when a policy is active, my problem is that if a customer has 5 records in this new table, I am printing 5 lines for the same customer. I need to print the customer only once, and populate the indicator field if there is an active policy in the new table within those 5 records.

Thanks in advance for any help you can provide!

IP IP Logged

Joined: 21 Dec 2007
Online Status: Offline
Posts: 4307
Quote lockwelle Replybullet Posted: 20 Oct 2020 at 5:36am
It seems to me that the join is creating the duplicates.

The simplest solution, is to create a group on the customer field, and place everything from the detail line into the group header, then suppress this new group's detail and footer...poof, only 1 line per customer.

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.032 seconds.