Incomplete or Incorrect Database Login Information

Posted on 2012-08-12
Last Modified: 2012-08-25
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?
Question by:ruavol2
    LVL 100

    Assisted Solution

    Make sure the users have permissions to the file and the directory.

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


    Author Comment

    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.
    LVL 100

    Accepted Solution

    Do they have permissions to the Excel file?


    Author Comment

    Yes they do.

    Author Comment

    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

    Author Closing Comment

    thank you sir

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now