Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Field Trimming
Message
From
04/12/2006 08:46:07
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Report Field Trimming
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01174565
Message ID:
01174565
Views:
67
Dear Experts

Table1 has 5 fields as

fld1--c(10)
fld2--c(10)
fld3--c(10)
fld4--c(10)
fld5--c(10)

There is only one record in dbf as
fld1="a"
fld2="b"
fld3=""
fld4=""
fld5="e"

The data may be vary type,for example
sometimes all fields are filled
sometimes some fields are filled
sometimes all fields are empty

When I use as
alltrim(fld1)+alltrim(",")+alltrim(fld2)+alltrim(",")+alltrim(fld3)+;
alltrim(",")+alltrim(fld4)+alltrim(",")+alltrim(fld5)

then It show extra comma when some field is empty as
a,b,,,e

In report, I want to show data in only one field as
a,b,e

The filled data should print side by side with comma separation.

Please help
Next
Reply
Map
View

Click here to load this message in the networking platform