General information
Category:
Reports & Report designer
Title:
Report Field Trimming
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only