Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rpt Variable being obstinate
Message
From
06/11/2008 09:57:45
 
 
To
06/11/2008 09:30:54
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:
01360168
Views:
9
>>UI have 2 rpt vars: SumBooked and SumQuantity
>>SumBooked is set to calculate sum of Bookedcolumn
>>SumQuantity is set to calculate sum of Quantity column
>>The following happily prints the %age:
>>
>>SumBooked / SumQuantity * 100
>>
>>But when I convert it thus:
>>
>>STR( SumBooked / SumQuantity * 100) +"%"
>>
>>all I get is the decimal point.
>>
>>What am I missing here?
>>
>>'ppreciate it
>>
>>Terry
>
>Not enough room? What about Transform( SumBooked / SumQuantity * 100) +"%

Well, now 94.17 becomes 94..17 and the "%" doesn't show.

Not enough room is not the reason, as I have already tried expanding the field, but if it is a long string of *************** then what can you do.
- 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
Next
Reply
Map
View

Click here to load this message in the networking platform