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.