dcsimg
Results 1 to 2 of 2

Thread: SUM of Two Columns (HELP) CRYSTAL REPORT in VB.NET

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Location
    PH
    Posts
    11

    Resolved SUM of Two Columns (HELP) CRYSTAL REPORT in VB.NET

    My table name is "accounting"

    it has two columns named "Debit" and "Credit"

    Is it possible to have the sum of these two columns?

    example
    Code:
               INPUT:                      
    Debit              Credit                     
      200        +      -100      
      300        +      -300   
      500        +      -400      
    --------          ----------                  
     1000               -800
    I want it to appear like this in my Crystal Report:


    Code:
    Debit              Credit              TOTAL                    
      200               -100                100
      300               -300                 0 
      500               -400                100
    --------          ----------          ---------        
     1000               -800                 200


    I dont know what FORMULA I should use in Crystal Report
    Last edited by paparick07; Jan 20th, 2015 at 04:24 AM.

  2. #2
    Frenzied Member
    Join Date
    May 2014
    Location
    Central Europe
    Posts
    1,281

    Re: SUM of Two Columns (HELP) CRYSTAL REPORT in VB.NET

    sum({table.field}) should give you the sum of each data column. for the values in the total column you should be able to use a formula like {table.debit}+{table.credit}

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width