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?
WarwicklAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (125)

Computer101
EE Admin
0
 
wykabryanCommented:
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?  
0
 
WarwicklAuthor Commented:
I have supplied the username and password for SQL.  The excel spreadsheet is setup using ODBC.  
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
wykabryanCommented:
I believe on the excel if you type in administrator and leave the password blank it should solve this issue.
0
 
WarwicklAuthor 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?
0
 
wykabryanCommented:
no. I do not think it is a permissions with the network.  The report does run locally without issue correct?  
0
 
WarwicklAuthor 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
0
 
wykabryanCommented:
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.
0
 
WarwicklAuthor Commented:
tried using admin & administrator in the second option but both failed.
0
 
wykabryanCommented:
the error is something like invalid username and password?  
0
 
wykabryanCommented:
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.
0
 
WarwicklAuthor Commented:
Crystal rEport Viewer Error
'The database logon information for this report is either incimplete or incorrect'
0
 
WarwicklAuthor Commented:
yep the ODBC is setup on the server using excel driver
0
 
jainulapCommented:
Hi,
I am also facing the same issue. Can some one help me.

Thanks
0
 
WarwicklAuthor 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
0
 
xcaoCommented:
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
0
All Courses

From novice to tech pro — start learning today.