I have a schedule report that needs to print for different users to different printers at a specified time. Using a compiled report set to print at 2:00 a.m. would be super easy except ....
1. Each schedule needs to print to a specific printer (I don't mind hardcoding the printer names in) and I want to avoid writing this in VB.
2. You can save the printer when designing the report and it will save it in the compiled version, but subreports always print to the printer chosen at the beginning of the print job.
3. I want to avoid making a seperate .EXE for each user
I'd like to do this in a single .EXE, having each user's schedule as a subreport. Writing this as UFL isn't out of the question.
Any ideas ?
1. Each schedule needs to print to a specific printer (I don't mind hardcoding the printer names in) and I want to avoid writing this in VB.
2. You can save the printer when designing the report and it will save it in the compiled version, but subreports always print to the printer chosen at the beginning of the print job.
3. I want to avoid making a seperate .EXE for each user
I'd like to do this in a single .EXE, having each user's schedule as a subreport. Writing this as UFL isn't out of the question.
Any ideas ?