Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report Field Trimming
Message
De
04/12/2006 08:46:07
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Report Field Trimming
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01174565
Message ID:
01174565
Vues:
69
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform