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:
00305469
Views:
28
One more thing James,

Depending on the order you want the labels printed, you can include the Dummy field in the select and then either order by the dummy field (for the first copy of all labels printed, then the second copy and so on) or a field in the LabelSource cursor.

Cheers,

Andrew

>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform