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
