How to format TQRExpr

[Nick Ford]

Hi

How do you format the result of a float expression to show 2 decimal places,
comma thousand separator, and currency symbol?

Many thanks

Nick

[Max Topley]

float money ;
AnsiString str = CurrToStrF( money, ffCurrency, 2) ;

This will format a currency amount with 2 decimal places.
What currency symbol it shows, and whether it uses commas, is controlled by
locale settings. These are set globally with Control Panel/Regional
Options/Currency.

HTH,
Max.

------------------------------------

"Nick Ford" <ni...@nonesuch.screaming.net> wrote in message
news:8odu80$iq...@bornews.borland.com...

[Nick Ford]

Thanks - but how do I get that to work with a TQRExpr?

I have a TQRExpr whose Expression property is set to

SUM(qryStatement.Deposit)

Please, how do I apply a formatting function to that property?

Nick

[Thierry Andry]

Nick Ford a écrit dans le message <8oeatq$n5...@bornews.borland.com>...

>I have a TQRExpr whose Expression property is set to
>
>SUM(qryStatement.Deposit)
>

FORMATNUMERIC(String pattern, float)

just call the format function built with string operator

See QReport help for more details about String pattern

[Nick Ford]

Thanks Thierry

but I can't crack this problem. I set the Expression property to the
following but it doesn't work:

FORMATNUMERIC("#,##0.00", SUM(qryStatement.Deposit))

I can only find limited help on this in my documentation so I'm struggling!

Many thanks

Nick

[jca...@gmail.com]

El lunes, 28 de agosto de 2000, 3:00:00 (UTC-4), Nick Ford escribió:
> Hi
>
> How do you format the result of a float expression to show 2 decimal places,
> comma thousand separator, and currency symbol?
>
> Many thanks
>
> Nick

in properties MASK put the format ###,##0.00