crystal server 2011
Posted on 2013-02-01
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.