Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove line if blank in a label
Message
From
29/03/2006 14:20:22
 
 
To
29/03/2006 14:11:45
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:
01108933
Views:
15
>>>>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.
>>>
>>>Goes all the way back to dBase ][.
>>
>>That's what I thought also, but wasn't sure. I still find is strange that this trick is so little known.
>
>I only had to write three or four lable programs in dBase. Wish I had known about this way back then. I spent a lot of effort shifting variables around when there were blank fields to supress.

You can do this in a report also, I use it for my invoices, packing lists and reminders.
Previous
Reply
Map
View

Click here to load this message in the networking platform