I have created a Crystal Report using Crystal Reports XI. In terms of a datasource I simply used a unc path to the actual mdb file.
I can open the report local on the PC in CR XI and the report runs no problem however I have deployed to our Crystal Reports server XI so that users can use it.
The problem is that when I try to run the report from the Info view console it keeps asking me for a user id and password. I have logged into the CMC admin console and looked at the properites of the report and the process/database tab however not matter what I configure in there it either asks for the username and password or says invlaid object when I try to view the report.
I have created other reports which have used an SQL database as the data source and published them to the CR Server and they work no problem so I am guessing I need to change something for using an Access DB as the dataource. Not usr eif that change is in Crystal Reports XI or Crystal Reports Server?
Can anyone help?