Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page height for labels
Message
From
28/03/1998 18:18:48
 
 
To
28/03/1998 02:31:15
Raul Davila
Davila Programming Services
Toa Alta, Puerto Rico
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00087883
Message ID:
00087944
Views:
26
Yeah it's sort of a pain. Windows isn't likely to recognize the label height unless you have some funky hardware that I don't know about. The spaces at the tops of the various Avery standard labels are also standardized, and if you create a new label, Foxpro will put in the right space on top depending on the Avery label you choose, which you can alter for custom applications. You have to create the label and format again, as far as I know, for each label type your users might use. You can store all the label names in a table and provide a combo box. In the table you can also put the names of all the reports, and have them called from the label printing program in a standardized way. You also should add an EXTERNAL reference to the reports in your main calling program so they get stuck in the project.

So, basically:
1. Make a label in each format (Cut & paste once you are happy with one)
2. If you have a lot of them, make tables with the following info: (You can list reports and labels in the same table if you make the R2_RF_KEY=0 when it is a report not a label.)

Table # 1 - reports/labels
RP_NAME (Report name - C 40 or so)
RP_KEY N 10,0

Table #2 - reports in various formats
R2_RP_KEY (N 10,0 Reference the report name)
RP_RF_KEY (N 10,0 Reference the report format)
RP_REPORT (Name of the report/label itself)

3. Make a table listing formats
RF_NAME C40 or so. e.g. "Avery 1234 - 4.5" x 6")
RF_KEY N 10,0 Key for reference by RP_ database
4. List all reports as EXTERNAL REPORT blahblahblah in your main calling program
5. On your form you can include 2 combo boxes, one for report names, and one for formats. Of course, you'll have to get a little tricky refreshing the combo boxes when they switch titles, to reflect which formats you HAVE of that label.

-Adam
Previous
Reply
Map
View

Click here to load this message in the networking platform