Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formating Numbers in VFP Report 1

Status
Not open for further replies.
MAliShah

MAliShah

Programmer
Nov 22, 2002
27
Dear All
I want to format the numbers in Visual FoxPro Report . Like -99999 as -99,999 and -999 as -999 not -,999. when i use 999,999,999 in format mask. it did not work. Please help.
Muhammad Ali Shah
 
Sort by date Sort by votes
Hi Muhammad,

Use the TRANSFORM() function, passing a formatting string as the second parameter. For example, if the field is called Amount, the expression might be TRANSFORM(Amount,"999,999").

Mike


Mike Lewis
Edinburgh, Scotland
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

infinetecode
  • Question
VFP Report : Dynamics
Replies
4
Views
164
Chris Miller
Chris Miller
Sng1
  • Question
Fill Full page till footer space in detail in FRX Report in VFP
Replies
19
Views
652
mjcmkrsr
mjcmkrsr
A_Radiolog_inFoxPro
  • Solved
GETWORDCOUNT () IN VFP 6.0 ?
Replies
11
Views
613
StefanFoerner
StefanFoerner
RTD78
  • Question
VFP Form Refresh
Replies
2
Views
203
RTD78
RTD78
sdocker
  • Question
InstallShield and VFP 9 Merge Modules.
Replies
11
Views
616
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top