Crystal reports server and microsoft access db

[Former Member]

Hi

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?

Many thanks

[former_member11696]

Please re-post if this is still an issue to the Business Objects Forum or purchase a case and have a dedicated support engineer work with your directly

[Former Member]

Try this

Symptom

Access files present on the network drives.

Create a report based on files on the network drives.

Reproducing the Issue

Create a Crystal Report using Access and Excel files on the network drive as Data Source.

Crystal Reports XI Release 1, Release 2.

Operating System: Windows XP SP2

Database: Microsoft Access / Excel.

Resolution

On the Windows XP system go to Start -> Settings -> Control Panel.

Double Click on Administrative Tools.

Double Click on Data Sources (ODBC).

Click on the System DSN tab and then Click on Add.

Select a driver for which you want to set up a data source.

For Access Files select 'Driver do Microsoft Access (*.mdb)' as driver type and then click on Finish.

For Excel Files select 'Driver do Microsoft Excel (*.xls)' as driver type and then click on Finish.

Enter the Data Source Name and under the Database option click on Select.

Then click on the Network button, Map Network Drive window will appear.

Select the Drive and Folder where you have the Access and Excel Files on the network and then click on Finish button.

Select the appropriate Directory where the file is located and double click on the folder and select the Excel or Access files depending on the driver you have selected and click on OK button.

After the DSN is created click on OK button.

Open the Crystal Report application.

Click on create New Report.

Under the Available Data Sources expand the Create New Connection then expand ODBC (RDO) and select the newly created Data Source Name and then click on Finish.

Select the appropriate tables and create a report as per the requirement.

Keywords

Excel Access Crystal Reports Network Drive

Regards,

Raghavendra

[Former Member]

Hi

Thanks for the response

I think I actually tried to do what you suggested however will give it another go and let you know.

Thanks

[Former Member]

Hi

I tried that but it it bascially gives me the

Unable to retrieve Object.

Failed to open the connection errors

If I look at the properties of the report in the cmc admin site on the process then database option under "Use original database logon information from the report" the database box is blank which is why I assume the error is being generated.

If that is the problem how do I get this box populated, is something I need to save in the actual report before it is published to the Crystal Reports Server.

In my other reports (which use an SQL Database) this database box is populated with the actual DB name.

Thanks