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.
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.