Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Specifying Format in a variable
Message
 
 
To
11/06/2010 10:27:44
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01468515
Message ID:
01468525
Views:
44
>>>Naomi suggests preparing the formatted value in advance; in addition to that, you can also use the transform() function in the report expression itself ( I suspect this would be simpler). Just set the report expression to something like:
>>>
>>>
>>>transform(MyField, pcFormatExp)
>>>
>>>
>>Hilmar,
>>
>>This seems to work fine.
>
>I think I did that on some occasion.

I've updated my reply with the simple test I tried:
lcNumber = '1235678790'
lcFormat = '999,999,999'
?TRANSFORM(m.lcnumber, m.lcformat)
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform