Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of times to print
Message
 
 
To
12/11/1999 17:53:32
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00290753
Message ID:
00290820
Views:
27
>I copied and pasted them 7 times on the report, but I can't fit all twelve instances of the information on one page. I get the error - detail band is too large to fit on page. I need five more instances of the information. How do I do that?
>
>I tried the label designer but it doesn't use my cursor for its information. It just pulls all the info out of the student table. The report does what I need it to do but I need the information to print 12 times. I don't know if that helps. Thanks for all your help.

Here is what I would do to print 12 labels for a student.

1) All the student data into vars (lcStudentName, lcStudentID...)
2) Use the label desiger to create the label layout, the size of the label and how many columns/rows. Be sure to remove your table from the label designer's data environment.
3) Create a cursor to hold the data
* note this is off the cuff, see VFP help for actual syntax

CREATE CURSOR cStudentLabels (...see VFP help for the field definitions)
FOR i = 1 to 12
 APPEND BLANK
 REPLACE cStudentLabels.Name with lcStudentName
 REPLACE cStudentLables.StudentId with lcStudentId
 ... and so on
ENDFOR

SELECT cStudentLabels
LABEL FORM lStudent TO PRINTER PROMPT
Previous
Reply
Map
View

Click here to load this message in the networking platform