Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question