We help IT Professionals succeed at work.

Running a report in CMC using excel data source

Have a crystal report using a SQL db and excel, report runs fine in designer, but when I run the report in CMC it asks for user ID and password for both SQLdb and the excel.  How do I setup a user ID and password for the excel?
Comment
Watch Question

you will need to supply a username and password for the sql db.  Do you have the excel sheet set up as an odbc connection?  

Author

Commented:
I have supplied the username and password for SQL.  The excel spreadsheet is setup using ODBC.  
I believe on the excel if you type in administrator and leave the password blank it should solve this issue.

Author

Commented:
I had read that the username is admin and blank password and tried this.  If I try Administrator/blank password in ODBC it come up with invalid username.  Do you think it could have something to do with permissions through the network?
no. I do not think it is a permissions with the network.  The report does run locally without issue correct?  

Author

Commented:
yep runs no problem.  The excel spreadsheet is not even on the local machine.  You are right though as CMC is asking for databse logon information, not network
You are running 10, so at the bottom there should be a check box that says something like Prompt the user for database logon when viewing.
Also make sure that you are using the second option - Use Custom Database logon information specified here and choose ODBC.

Author

Commented:
tried using admin & administrator in the second option but both failed.
the error is something like invalid username and password?  
Another question.. it the ODBC connection set up on the server?  It must exists in the odbc connection tab under control panel on the server.

Author

Commented:
Crystal rEport Viewer Error
'The database logon information for this report is either incimplete or incorrect'

Author

Commented:
yep the ODBC is setup on the server using excel driver

Commented:
Hi,
I am also facing the same issue. Can some one help me.

Thanks

Author

Commented:
I couldnt get it to work until I put the excel spreadsheet into a Access Database and then setup an ODBC connection to this with a username and password.  Need to ensure that you use UNC path when connecting to the Access DB
PAQed with points refunded (125)

Computer101
EE Admin

Commented:
Hi,

I have the same issue with my excel data source.
Did you finally get it solved it or not?
Could you give me some advice, thanks