Removing Duplication in Detail Section
Here is my report:
I am trying to remove duplication in the Data Field.
I have tried:
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.
Dell Stinnett-Christy 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().