Crystal Report creating a receipt register report

Question

This question is related to my first question, see it here: Crystal Report creating a receipt register report

I already done some parts of my report with the help of a good person(Siva) but I'm on much bigger problem I think. It's about my sundries section.

In my table

and I want to display my report to look like this.

And this is what I'm getting...

You can see in my table that the record with RefNo: 1003 has a lots of account that has been paid. Unfortunately the reports I'm getting has no record of AccCode: 4200 Housing Loan with a credit of -$40.

I don't know how to achieve this again... I'm placing all the details in a group footer of field name RefNo.

Please someone can help me to this, you can just give me some idea and I try to handle it. Thanks in advance.