I am just trying to view a report and then print it automatically. Very simple.
I have a button that opens the report and then prints right away. The problem is that in print preview the page looks blank when the print screen comes up, so there's no way to check it the report is correct (user errors are very common and reports need to be double checked before printing). The report prints with all the information though so it is loading, I just want to avoid wasting paper if the data entered is incorrect.
I have tried adding a timer to allow time for the data to come up, but the timer wont fire in print preview, and the automatic print wont work in the report view (the print screen comes up but nothing prints).
I have also tried opening in report view, having a 2 second timer and then opening the report in Preview to print, but the report requires that the user enter a month, so opening it twice then requires the user to enter the month twice, which I would like to avoid.
Users can simply print by right clicking and selecting print from the shortcut menu but this has proven to be a difficult and confusing thing for multiple of the database users and part of my job is making this as user friendly as possible.
Any ideas?