Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove line if blank in a label
Message
From
29/03/2006 12:36:30
 
 
To
28/03/2006 13:37:18
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01108475
Message ID:
01108887
Views:
14
>Hi All
>I try to use the Remove line if blank in a label and the line is
>allways there. I've make shure that there nothing else on the same line
>and i use a print when.
>
>The print when works fine but the line is always there
>
>any tips !
>
>TIA. !
>
>
>Ben.

I will show you a great, well hidden, trick which has been there since Foxpro DOS.

On the label you create a field which is big enough to show what you want, like a box. Enter all the information you want to show in the Expression box, like this:
firstname,lastname;address1;address2;shortstate,zipcode;country.
All the fields which are separated by a komma, will be properly formatted with one space between the trimmed values. If the first value is blank, the second value will come first.
All fields which are separated with a semikolon, will come on a new lines, and blank lines will be skipped so that the next value is shifted up.

I guess this is exactly what you want to achieve?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform