Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Report Field Trimming
Versions des environnements
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement