Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing multiple labels
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00107194
Message ID:
00108721
Views:
33
>I'm sure this topic has been covered before, but I couldn't find anything about it in the KB so...
> I'm trying to print multiple copies of the same label, using a single record and a FOR...ENDFOR loop. This works, but each label prints every 8.5 inches instead of every 4 inches (my label size). Do I have to create a table with multiple duplicate records for this to work properly or is there another solution?
>
>TIA,
>Paul M.

The easiest way that I've found to print multiple labels is to create a temporary cursor and fill it with the duplicate records and then run the report/labels

If the user states that they want four copies:
1. Do your query, to get the results.
2. Create a cursor to match the structure of your query.
3. Scan through the results
4. Use your for next loop to insert desired number of copies.
5. Print/View the report.

Real silly example to give idea

maxloop=4
crea cursor filltest(labelfield1 c(10))
sele labelfdield1 from labelinfo into cursor test
scan
scatter memvar
for x =1 to maxloop
sele filltest
append blank
gather memvar
endfor
sele test
endscan
label form testlabels to print noconsole

Used this idea with a form... allowing user to select number of copies, copies to line up on page correctly etc.


HTH
Mike
Previous
Reply
Map
View

Click here to load this message in the networking platform