Skip to Content
Former Member
Sep 29, 2017 at 09:36 AM

Executing CR2013 report based on XLS from SAP BI server


I'm trying to set-up a scenario where:

  • we have .XLS file on a network drive (>> i specifically use an .XLS and not XLSX since the DOA-connection does not work with these newer excel versions)
  • on which a CR2013 report is built that is stored on the BI 4.1 SP6 server
  • and where the crystal report should be published automatically via 'Publication' on BI

For this i created the CR2013 report via the DOA connection ("Excel 8.0") and i can create run the report fine from with the CR2013 desktop application (with the .RPT file being stored on the BI server)

When i open the RPT report via the CMC or the launchpad (right click > view), it opens ok, but when i try to refresh, i'm asked for a database logon.

No matter what i fill in (my own credentials, the credentials of the SIA user,..), nothing is accepted. I also tried numerous options in the 'Database configuation of the context menu, no result..

>> Is this scenario feasible?

(additional info : the SIA user has access to the .XLS file since a parallel setup with WebI works: i can create a Webi document on the same file and am able to schedule/push this webi via the Publication functionality)