Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rpt Variable being obstinate
Message
From
07/11/2008 06:28:17
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01360157
Message ID:
01360419
Views:
7
>>>You have to specify the width and the decimal places when using STR(). Try this:
>>>
>>>? STR( SumBooked / SumQuantity * 100,5,2) +"%"
>>>
>>>
>>>Regards
>>>Kevin
>>
>>Good point,Kevin, but you don't need to. That is to be precise about how many sig figs, dec places etc. But an argumentless STR() returns a value OK.
>
>Hi,
>From Help:
>If nLength isn't included, the length of the character string defaults to 10 characters.
>If nDecimalPlaces isn't included, the number of decimal places defaults to zero.

Hi Viv

Sure, but what I meant was: just STR()ing the number does not wipe it out, as happened on my rpt, unless it is less than 0 - it still returns a value. The problem was that I had rpt object property set to format it, which conflicted with the actual value, and I was getting blank values. It's since sorted with a TRANS() and no property formatting.

Thanks for the input.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform