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