Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
User ability to designate a report-specific printer
Message
 
To
18/01/2013 14:40:56
Stan Vaninger
Mitek Industries, Inc
Missouri, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01562970
Message ID:
01563316
Views:
81
>I have just been informed that we need to enable the user to specify not only a report-specific printer but also to be able to select a tray, number of copies, and other such properties.
>
>Thus without any user intervention at print time, a certain report will always be directed to the specified printer, use the specified tray in that printer and print the specified number of copies, etc.
>
>Is there any way to do this other than to open the frx file and write this info to the Expr field?
>
>Thanks very much for everyone's input so far.
>
>Stan

It certainly can be done IF all users have access to the same printers. Otherwise it gets a lot harder.
Create a table of printers and reports. In that table list all reports in field 1. In field 2 enter the full name of the printer to be used for that report. When the user selects a report look it up in the table and SET PRINTER TO whatever is in field 2 (printer field).

If different reports require the same printer but some are duplex, need to access different trays or whatever then you need to install a new printer on each PC (same printer different settings) for each method need to print the report.

Have fun. Over the years I have found printers to 10 times harder to setup than anything else. Way back when I could setup a 10 station Novell network in two days then spend two weeks setting up the printers. Today it takes at least as long.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Previous
Reply
Map
View

Click here to load this message in the networking platform