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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
wykabryanCommented:
I believe on the excel if you type in administrator and leave the password blank it should solve this issue.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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
Computer101Commented:
PAQed with points refunded (125)

Computer101
EE Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.