[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3512
  • Last Modified:

Incomplete or Incorrect Database Login Information

I have created a Report in Crystal Reports 2011 that uses a .xlsx file as the database.  I can open and view the report in Crystal Reports but when I try to open it through the BI Launch Pad I get:
The viewer could not process an event. The database logon information for this report is either incomplete or incorrect. []
---- Error code:0 [CRWEB00000119]
The permissions are set correctly to view the report.  
I have tried every combination of username and password (from user that is trying to login to administrator passwords) with no success.
In the Crystal Report I set the connection as:
\\server\documents\thread gage usage\Thread Gage Usage.xlsx
This is the only report I have that uses an excel connection all others connect to a SQL Server database and work fine.
What step am I missing?
0
ruavol2
Asked:
ruavol2
  • 4
  • 2
2 Solutions
 
mlmccCommented:
Make sure the users have permissions to the file and the directory.

Did you specify the location when you pubished the report to BI?

mlmcc
0
 
ruavol2Author Commented:
I double checked and users do have permissions to the directory and file.
Here is the way I have set-up the reports.
1.) I have the main folder where all of the reports are located.
2.) I have another folder with subfolders that are named after the people using a report.
3.) In these subfolders I have created shortcuts to the main folder reports they need.
It works well for all of the reports that are linked to the SQL Server database, but when I try to open the report that is linked to the .xlsx document I get the error.
In database configuration I have tried to add a username/password and leaving it blank.  All with the same resulting message.
0
 
mlmccCommented:
Do they have permissions to the Excel file?

mlmcc
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ruavol2Author Commented:
Yes they do.
0
 
ruavol2Author Commented:
Apparently there is a bug in the product. I am going to reward points becuase you verified and had me check all the possible solutions. Thank you mlmcc
0
 
ruavol2Author Commented:
thank you sir
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now