I have report display like this:
Owner Name | Doc No | Date | Amount
----------------------------------------------------
Andy | 1 | 1/Jan/2022 | 1000
| | 1/Feb/2022 | 2000
| 2 | 1/Jan/2022 | 1000
| | 1/Feb/2022 | 1000
------------------------------------
Total | 5000
Grace | 1 | 1/Jan/2022 | 2000
| | 1/Feb/2022 | 1000
------------------------------------
Total | 8000
In the owner's name and document number, I use Suppress If Duplicate. I want to give the distance between item document number 1 with document number 2 for each group of owner names. Document number is not limited. I'm trying to divide the detail section into 2, and use a formula to check the previous value and the next value. But what happens is that there is a gap between the last document number and the total, and the total line spacing becomes too close to the next owner line. How to give a distance between different document numbers but the last line document is not given a distance with the total? Or is there a better solution ? I appreciate your answer.
Expected Result:
Owner Name | Doc No | Date | Amount
----------------------------------------------------
Andy | 1 | 1/Jan/2022 | 1000
| | 1/Feb/2022 | 2000
| 2 | 1/Jan/2022 | 1000
| | 1/Feb/2022 | 1000
------------------------------------
Total | 5000
Grace | 1 | 1/Jan/2022 | 2000
| | 1/Feb/2022 | 1000
------------------------------------
Total | 8000