I need to calculate the sum of one of the columns on crystal report - Need help
-
Hi, I am using DataSet as a datasource to my CrystalReport and I have no problem in displaying the data. But there is a column called MoneyWithHeld and I am trying to find a way how to calculate the sum or total of these values. I searched online and have found two possible solutions 1).Using Formula Fields -- Created a field called TotalWithHeld and in the formula I just put Sum({DataSet.MoneyWithHeld}) and that is it but no luck. I am pretty sure I have missed some thing else here but not sure what it was. Becuase while I was trying to save this TotalWithHeld field I ran into some syntax errors and as a result of those while trying to run the report the error was 'The function cannot be used because it must be evaluated later' . 2).Running Total -- I picked my DataSet.MoneyWithHeld filed to 'field to summarize' text box and I picked the "Sum" under type of summary drop down. When I run my app it wouldn't give me any error as it was in the case #1 but it wasn't displaying the total but just the last value of the MoneyWithHeld in the last record. I tried picking the Count, distinct count but nothing has worked. Looks like here too I need to put some kind of formula by selcting the radio button 'use a forumula' but not sure how to put it to get the total. I am kind of new to this Crystal reports would some one be kind enough to help me with this? Thanks, -L