Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remove line if blank in a label
Message
De
29/03/2006 14:20:22
 
 
À
29/03/2006 14:11:45
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01108475
Message ID:
01108933
Vues:
14
>>>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform