Display Format with negative valueproblem

rbuser

I am trying to display the number into "$#,0.00;($#,0.00)" format. I
used TppDBText and set DisplayFormat to "$#,0.00;($#,0.00)", but it
still should the negative number in format -0.00, instead of (0.00)



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Raymond,

Where and when are you setting the display format? In my testing with the
latest version of ReportBuilder and a simple Query using the DBDEMOS
database, negative values were showing up with parenthesis rather than a
negative sign.

My Query:

Select (orders.AmountPaid - orders.ItemsTotal) orders_AmountPaid_orders
From orders

--
Regards,

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

nardmoseley

>I am trying to display the number into "$#,0.00;($#,0.00)" format. I

Please see the following rbWiki article

http://www.digital-metaphors.com/rbWiki//Design/Formatting/Currency_Formatting



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com