How to set Crystal Reports default printer in a formula?

dticson
dticson used Ask the Experts™
on
My organization has about 50 reports, all which have the same content, and only differ with their default printer that is set in each report, one report for each location.  I'd like to replace these reports with one report that can change the default printer based on the location of the office, which will ideally be determined by a a formula in the report.  Is this possible?  We are using Crystal Reports XI
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
The report cannot change its default printer.

One thing to try.
On the development machine add a "LOCAL" printer.
The printer doesn't need to exist or it can be a printer that doesn't exist at any location.
Just make it the same printer family that is used at all locations.
Set the new printer as the default for that machine.
Open the report
Change the printer to the default printer
Save the report

It should now use the systems default printer at all locations since it cannot find the printer it was developed with.

mlmcc

Author

Commented:
Thank you for the quick response.  The problem with your proposed solution is that our default printer at each location isn't necessarily the printer we want it to go to.  Each location has a specific printer that they need these requisitions printed to, it may be in their office or somewhere in a back room somewhere.  So we need to set it for each site/report.

Can this be done with VB/C## version of Crystal Reports?  I've used that version a little in the past, but not quite sure how the C##/VB code is integrated with the actual .RPT file, as that's the only thing we can expose to our 3rd party report viewer - we run these crystal reports through another program that just takes a .RPT file.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Only through the application that runs the reports and that isn't always accurate.

If you don't have control over the applicatiion then the way you are doing it is the way to go.

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial