Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
User ability to designate a report-specific printer
Message
 
 
To
16/01/2013 16:16:03
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:
01563058
Views:
79
>>>I need the ability of the user to specify that a particular report will always be
>>>sent to a certain printer without the user having to select it every time the
>>>report is printed.
>>
>>Create a form that links reports to printers. Before you run each report, access that table and set it to the indicated printer. Use the APRINTERS() function to make sure the printer they've setup on that form still exists in context on the local user's machine.
>>
>>>For example, all invoices will be sent to a pre-selected printer disregarding
>>>any default printer settings at the workstation where the report was printed.
>>
>>Yup. That'll do it.
>
>In that table that links reports to printers I would also add a user_ID and, for good measure, the option to view on screen and to be asked for a printer if you want.
>

What I have seen is that when you want to print a particular report to a specific printer -- on preprinted forms, for example -- there will often be many users sending the report to that printer. Maybe you can manage that with a 1:M:M relationship between reports, printers, and users but IMO it would be a nightmare to administer. I would leave the user ID out of it and control that by user access to the report in the first place.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform