General information
Category:
Reports & Report designer
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
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