Skip to Content
0
Former Member
Jun 17, 2015 at 01:30 PM

Can SAP Crystal Reports Viewer 2013 be programmed using MS Access?

491 Views

Hello, I have been researching this online but have found it difficult to get a definitive answer.

Can SAP Crystal Reports Viewer 2013 be programmed using MS Access? One comment suggests that:

CR does not support VBA scripts any more because there is no ActiveX report engine component now...... have to use a third party tool .

Does this apply to the Viewer as well? Are there any (free) recommended 3rd party tools to achieve this?

The context is: I have multiple crystal reports that are exported from SAP and dumped into a network location. Each needs to be converted to excel before being imported into an access database. I have Crystal Reports viewer and I'd like to programme it (using access VBA) to open each report and save it as excel in a new network location. I have downloaded two library references for use in Access that I thought were relevant (crviewer.dll & craxdrt.dl). However, this is not something that I've been able to achieve.

Any suggestions/comments would be appreciated. Thanks.