Using Excel as a Datasource

[Former Member]

I created a report that will use Excel as a datasource. The report runs fine from my desktop. I would like to place this report on the Business Objects Server. Can anyone tell me what I would need to do in regards to the excel file.

In addition to this issue, when I moved the excel file to a shared folder and reconfigured the system dsn, the report would not run. I received an error message: could not decrypt data. Any help would be appreicated. Thanks.

[former_member260594 · Accepted solution]

Donald,

You should be able to just set datasource location (under the database menu in CR) to the odbc connection you created the report with. Publish the report to Enterprise and as long as you have the DSN on the Enterprise server it should run wihtout issue.

[Former Member]

Thanks for the responses. I created the DSN on the enterprise server and I saved the report on the enterprise server. When I run the report it is asking for a user name and password. When i created the dsn, there was no option to set up a user name or password. The excel spreadsheet is not password protected. Any thoughts?

[Former Member]

I have the same issue, tried using an ODBC driver with Excel but this also does not work.

Where you able to get around the username and password issue with Excel as datasource?

I can run the report from within Crystal Reports fine, but not from a Crystal Viewer.

Edited by: Matthew Vorpasso on May 1, 2009 3:27 PM

[Former Member]

Hi

Put the excel file on a network drive which is accessible by the server.

Create a Crystal Report using the Access/Excel DAO connection based on the above excel file.

Save it to the enterprise.

Hope this helps!!

Regards

Sourashree