crystal server 2011

I have a  new Crystal Report that is connected to an Excel file.  When I try to set the "Database Configuration" in Crystal Server so others can view the report everyone gets an error message stating: 'The viewer could not process an event. The database logon information for this report is either incomplete or incorrect."  They have all of the rights they need to the folder on the server and also the rights needed to view the report.
I have it setup using under "Database Configuration" as:
"Use original database logon information from the report. " and "Use same database logon as when report is run".  I have tried every combination of user and password that I can think of.  I have also changed the "Use same database logon as when report is run" to "Prompt the user for database logon (viewing only)" and the report will open to a screen prompting for a user and password but no combination I can think of works.  The strange thing is, I thought I had it solved.  I finally put in "admin" as the user and no password and it worked.  I added data to the Excel file and now it does not work any more even when I use "admin" with no password.
I have many reports setup against a SQLServer database and they work fine.
slmcAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
Does the LaunchPad user have permissions to the shared drive?

mlmcc
0
 
mlmccCommented:
Is the file on a shared drive?

Are you running on the server or on the workstations?

mlmcc
0
 
slmcAuthor Commented:
Sorry, I have been out for the week.
Yes, the file is on a shared drive.
I can access the report using Crystal Reports but when anyone tries to access the report through BI LaunchPad it gives the error.
0
 
slmcAuthor Commented:
That was it.  I had the upper level folder shared but had only given permissions to the folder the excel file was actually in.  Once I shared that folder it worked.  Thank you for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.