Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing same record more than 1x
Message
From
19/07/1997 00:33:10
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00039641
Message ID:
00040717
Views:
28
This is one of those little used 'tricks' of SQL. It's generally ignored, because it is generally the result of an error in the SELECT. Essentially, you want to print each record say 3 times. That is, you want the cartesian product of the number of records and 3. Here's the original code: select * from records into cursor stuff report form whatever Here's the new code: create cursor junk (dummyfield c(1)) append blank append blank append blank select * from records, junk into cursor stuff report form whatever This will take each record in {records}, multiplied by the number of records in {junk} and print out that many labels. > I've designed custom price tags for a small clothing manufacturer in Report > Designer. What I need is a way to print, let's say any given item, more > than once (in fact, user defined amount of times). Each item is > represented in an inventory table as separate record. Each style, size, > color have an unique code assigned to it (primary key). > How can I print X number of same information stored in a record in a Report > w/o creating a, let's say cursor that holds x number of same record as > records? Any ideas???
Paul Russell
EMail: prussell@fox.nstn.ca
Phone: (902) 499-5043
Previous
Reply
Map
View

Click here to load this message in the networking platform