Steve McFarland
asked on
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.
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.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Are you running on the server or on the workstations?
mlmcc