Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Labels - three labels for each record
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00305398
Message ID:
00305563
Views:
22
For me, I use a Local View instead!

Create a Table called PrtNum {nCopies N[8]}
Well, I put a natural number on it by:

select prtnum
For ix = 1 to 1000
append blank
replace ncopies with ix
endfor

At the Same times, add a nCopies N[8] on your Table..

For the Local View, I do:
Create SQL View PrtLabel As ;
Select ShipData.* From ShipData, PrtNum ;
Where ShipData.nCopies >= PrtNum.nCopies

Then, When know the number of copies user want to print:
Just Simply Replace the ShipData.nCopies Value!

It would work fast as you have made a dummy table PrtNum,
no need to waste N time to append dummy record to cursor to print Each Time!!

^_~

>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
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Reply
Map
View

Click here to load this message in the networking platform