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
Newbie
Newbie
Avatar

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:

If {INSURANCE_SYSTEM} = 'COVERAGE' and
    {POLICY_STATUS} = 'ACTIVE' Then
'Y'

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!
Frank

Frank
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4308
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.

HTH
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.016 seconds.