Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conditionally formatting numeric fields
Message
 
 
To
24/04/2008 18:14:29
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01312990
Message ID:
01313164
Views:
10
>Sergey,
>That's it! Thank you.
>********************
>Naomi,
>when you have VFP at hand, please try it:
>make report,
>set DE to use home ()+"labels"
>add one field for ckval
>write in the format expression (you will find on page Format of the Field Properties form)
>
>iif(readonly=.f., alltrim(transform(ckval, "@ 999,999,999.99")) + " + ", transform(ckva,"@ 999,999.99"))
>
>I see only stars.
>
>For timebeing I will use Sergey's elegant solution, easier for future maintenance anyhow.
>Definitely good bye for today.
>Koen

Ok, I found that it should have been alltrim(transform(number,'@R 999,999,999.99')) instead. Note the R format clause.

http://msdn2.microsoft.com/en-us/library/3hb8xwke(VS.71).aspx
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform