What displayformat to use?

rbuser

Hi,

I can't seem to find the appropriate DisplayFormat for a ppDBText which
meets the following requirements. I want to surpress trailling zeroes in the
decimal part of the value.

Example:
Value Display
-1234.00 > -1.234
-1234.50 > -1.234,5
-1234.51 > -1.234,51

Greetings,
Filip Moons

nicocizik

Hi Filip,

ReportBuilder uses the FormatFloat procedure to format these type of
numerical values. If you would like to have your thousands separator be a
'.', you will need to define the Delphi global variable ThousandSeparator as
such. Same with the DecimalSeparator global variable. Once you define
these values, I believe you will want to use "#,0.##;-#,0.##" as your
display format.

--
Regards,

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