Page 1 of 1

Formatting Summary Floats(ssSUM)

Posted: Tue 18 Apr 2006 13:39
by mhanefitel
If a column holds the data of a standard double value, the value on the summary bar (ssSUM) is shown as scientific format. I want it as currency format, how can i do that. I selected ffcurrency from float fromat but the result is the same.
How to overcome this issue?
Thanks in advance...

Posted: Wed 19 Apr 2006 12:25
by Jackson
Try to work with FloatFormat, FloatDigits and FloatPrecision properties of the desired Column. To understand how it works, please see help on FloatToStrF function.

Posted: Wed 19 Apr 2006 13:00
by jfpicard
Also, ty in your SQL statement to do a cast or a convert to currency. Maybe that will help.