Hi James,
I do this by reporting from a cursor.
CREATE CURSOR CopyCount (Dummy I)
for i = 1 to NumCopiesRequired
insert into CopyCount values (i)
endfor
select LabelSource.*
from LabelSource, CopyCount
Into Cursor MultiLabelSource
select MultiLabelSource
label form LabelFormName to print noconsole noeject
use in MultiLabelForm
use in CopyCount
The key is the cartesian join - one record for each copy is produced
Cheers,
Andrew
>Hi All,
>
>I need to print three labels for each record, on a three across sheet.
>
>I've tried this:
>
>FOR mprint = 1 TO 3
>label form stlbshiptags to print prompt preview
>endfor
>
>But that just gives me three sheets, and I need each label three times on the same sheet.
>
>Has anybody done this?
>
>Thanks,
>
>Jim Harvey
>
jharvey@netrax.net
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.