Sum DBText

rbuser

I have in details section DBText with string value from database.
I would like to sum values from each record printed in details at end of
document.
How i can calculate total value of DBText with string ? I cannot use DBCals
with Sum property because it shows always 0.

rbuser

With the Dataset, create a calculated field.
In the oncalculate event of the field, convert the string to numeric and
then use this field in Reportbuilder.
You can then sum on this field

rbuser

Uzytkownik "Mike Hickman" napisal w wiadomosci

nicocizik

Hello,

For future reference please use your real name when posting to these
newsgroups.


This is not a known issue. Are you certain you are connecting the DBCalc
component to the proper field. Where are you placing the DBCalc component?
Ideally you will want to place the DBCalc component in the summary or group
footer band.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nicocizik

Sorry, In my previous post I failed to see that you are trying to sum a
string field. When trying to use a DBCalc component you will always receive
a 0 when connecting it to a string field.

In order to perform a sum of your string field you will either need to use
SQL as Mike mentioned or you can use RAP.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com