Skip to Content

Removing Duplication in Detail Section

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

CrystalReport.JPG (96.6 kB)
CrystalReport1.JPG (107.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 26, 2015 at 03:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 03:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 03:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded