Joined: 09 May 2014
Online Status: Offline
Posts: 209
Topic: Using Excel as a datasource Posted: 01 Dec 2014 at 11:39pm
Hi All,
I have a report which uses Databases as well as an Excel spreadsheet, setup as 'Access/Excel (DAO)', which works great when viewing/refreshing the report through the Crystal Reports application.
As I have done with numerous other reports I would now like to publish this report on the Central Management Console (CMC) to allow automation/users to view the report online.
When trying to do this I am being asked for a username/password of the Excel file, which does not exist.
I've searched online quite a lot for a solution and there are references to a UNC path and a username/password for a service account but I'm not 100% sure what the correct steps to make this work are.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum