View Full Version : Adding A value to Group Summaries ...


melbenmartin
12-18-2009, 12:10 AM
Hi I am Novice in crystal report .

Your help will be hightly appreciatable . Thanks in advance.
See ,I have one report

Group Field - Tbl_Transaction.BillDate
Summary Field is - TBL_transaction.Credit
Summary Field is - tbl_transaction.debit

when the report generates,

I need to display the Report Like this .

Opening Balance 2000.00
12/12/2009
----------

Particulars Debit Credit
----------- ------ -------
some texts 200.00 100.00
some texts 200.00 100.00
some texts 200.00 100.00
some texts 200.00 100.00
some texts 200.00 100.00
------------------------
Group Summary 1000.00 2500.00 (CreditGroupSumary + Opening Balance)
--------------------------------------------
C/D Balance is 1500.00 (CreditGroupSummary - debit GroupSummary)

13/12/2009
---------- C/D Balance (1500.00) +
Particulars Debit Credit
----------- ------- -------
some texts 200.00 100.00
some texts 200.00 100.00
some texts 200.00 100.00
some texts 200.00 100.00
some texts 200.00 100.00

Here I have to add the previous c/d Balance to the next groups Credit Summary .. and the same logic will continue for the subsequent groups ..

Plese help me how to do this functionality . Thanks in advance.
Please note : I could add the Opening Balance to the first groups credit summary ..

But i am not able to add c/d Balance to the next groups credit summary .. please help me on this as its very urgent

Regards,
Simon.