Running and saving a crystal report from an access form (1 Viewer)

[LMD]

At present we use an Access report to print a drivers Load Sheet, when the "Print Load Sheet" button is clicked a macro runs which saves prints the Load Sheet report, runs a few queries to flag it as printed 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 the Load Sheet report to open 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.

Thanks,

James

 

[kevlray]

It might be possible through a third party viewer. We do not use them, but a number of forums mention them often.