Sounds like the need is to have the development db connect to local printer and the production db connect to other printers. Just because a property is not exposed in the property sheet does not mean it isn't available via code. Perhaps before opening report, you get the Application.CurrentPath property. Have never done this, but perhaps if it is not the production path, then set the property accordingly as in
Dim prtDefault As Printer
Set Application.Printer = Application.Printers(n) << where n is the index of the printer for a pc.
If all production users connect to the same printer, perhaps use 0 for them, or you could have a table for printer index numbers specific to each user/station. You could load that value on app startup in a number of ways so that it doesn't have to be looked up every time you open a report. My laptop inkjet is (4), for example.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.