Auto export and print crystal report within access
At present we use an Access 2003 report to print a drivers Load Sheet, when the "Print Load Sheet" button is clicked on a form a macro runs which prints the Load Sheet report, then runs a few queries to flag it as printed (puts a tick in a field named "Printed" on a local access table) and then mails the Load Sheet details to the courier.
Ideally we need to replicate this behaviour but using a crystal report instead of access report. The back-end database has changed and re-writing the access report has proved to be impractical.
We are using Access 2003 and Crystal 2008 (for SAP Business One).
Would really appreciate any help on this, I have managed to get a crystal report version of the Load Sheet report to open from access by using the FollowHyperLink method but obviously this only opens the report.
If I could somehow open the report and automatically print and then save it then this would be ideal but I understand that this may not be possible. any help appreciated
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.