Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get labels to print w/o blank fields
Message
From
08/12/1999 18:42:43
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00300637
Message ID:
00300673
Views:
13
You could select the records into a cursor and print the labels from there. If the selection "rules" are simple enough, then SELECT - SQL may be sufficient. If the rules are complex, you'll probably want to set up a SCAN loop and INSERT the qualifying records into a cursor.
e.g.

SELECT name, address, city, state, zip ;
FROM labtab ;
WHERE NOT (EMPTY(name) OR EMPTY(address) ;
OR EMPTY(city) OR EMPTY(state)) ;
INTO CURSOR sellab

>How do I get labels to print from a table without printing the labels with incomplete information? For example, I have labels with name on one line, address on another, and city, state, and zip code on the next line. I want to maximize the label paper without printing the incomplete information.
Previous
Reply
Map
View

Click here to load this message in the networking platform