Removing Duplication in Detail Section

[former_member1107312]

Hello,

Here is my report:

I am trying to remove duplication in the Data Field.

I have tried:

{VENJobCompleted.Data}=previous({VENJobCompleted.Data})

That will remove previous duplication

Then I tried

Right mouse click on Data field and Suppress if Duplicated

Then it looked like this:

I just looking for a method to have a clean look to it.

Any suggestions?

Thank you,
Gerald

[DellSC · Accepted solution]

First, I would go to the Database menu and see whether turning on "Select Distinct Records" will resolve the problem.  If it doesn't, you could do a couple of things:

1.  Use the suppression formula on the section that the data is in instead of on a specific field in the section.

2.  Create an additional group on the start date/time field.  Put your data in the group header and suppress the details section completely.

Option 2 gives you the advantage that if you need to, for example, add together all of the times, you can do a running total and tell Crystal to only calculate on change of the date group.  If you use Option 1, you'll have to do a manual total on the minutes in a formula because if you just use the "sum()" function it will add ALL of the times, regardless of whether they're visible or not.  If "Select Distinct Records" works for you, you can use just sum().

-Dell

[former_member1107312 · Accepted solution]

Hello Dell,

That worked like a charm.

Thank you,

Gerald

[former_member205840]

Hi Gerald,

Here is other way of solving :

Create below formula New :

If Previous({data}) = {Date} then 0 else1

In the formula editor on top you will see ' Exception for NULLS' try to change this to 'Default Values for Nulls'

Now go in section expert and select Detail -- Click on X+2 button on Suppress then give below

If {@New} = 1 then true else false

Thanks,

Sastry

[abhilash_kumar]

Hi Gerald,

The right solution is to identify what is causing these duplicates by looking at the Joins. If you need a quick fix, try this:

1) Create a formula that concatenates all fields on the details section:

{ActualStartTime} & {Endtime} & {Data} & {Time}

2) Insert a group on this formula field

3) Move all fields from the Details Section to this new group's header

4) Suppress the Details Section and the Group Footer

-Abhilash