Print Page | Close Window

Adding a value to group summary

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8660
Printed Date: 29 Apr 2024 at 10:41pm


Topic: Adding a value to group summary
Posted By: melbenmartin
Subject: Adding a value to group summary
Date Posted: 16 Dec 2009 at 10:40pm

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 generate,

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  30000.00(CreditGroupSumary + Opening Balance)
       --------------------------------------------
        C/D Balance is     2000.00 (CreditGroupSummary - debit GroupSummary)


13/12/2009
----------                         (2000.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



-------------
TechRoberts



Print Page | Close Window