Formatting Summary Floats(ssSUM)

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 7
Joined: Fri 23 Sep 2005 12:26

Formatting Summary Floats(ssSUM)

Post by mhanefitel » Tue 18 Apr 2006 13:39

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...

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Wed 19 Apr 2006 12:25

Try to work with FloatFormat, FloatDigits and FloatPrecision properties of the desired Column. To understand how it works, please see help on FloatToStrF function.

Posts: 24
Joined: Tue 06 Dec 2005 21:17

Post by jfpicard » Wed 19 Apr 2006 13:00

Also, ty in your SQL statement to do a cast or a convert to currency. Maybe that will help.

Post Reply