I need to create a balance sheet report using crystal report 10 & vb6 (yes it's a bit antique), heheh.
my current recordset is like this :
AccountHeaderNumber AccountNumber AccountName Debit Credit
And i'm trying to build a report like this,
AccountNumber1 AccountName1 Account1Total (debit - credit)
AccountNumber2 AccountName2 Account2Total (debit - credit)
TOTAL AccountHeader1 (sum)
AccountNumber3 AccountName3 Account3Total (debit - credit)
AccountNumber4 AccountName4 Account4Total (debit - credit)
TOTAL AccountHeader2 (sum)
The problem is,
AccountHeader2 value == AccountNumber2 value (and i group them using accountheader field), is there a way to join them together instead separate it in a different group ? Or should i redesign the report in a different way ?
Attached is the screenshot of the report.