Crystal Reports Server 11 -- Error Failed to open the connection *.rpt

Posted on 2006-05-17
Last Modified: 2012-08-14
When publishing any report to Crystal Reports Server (11) and running the report via Infoview......if the report has a PARAMETER the following message is received "Failed to open the connection" (*.rpt).  If the report's parameter is removed the report runs fine.  These reports have been tested with the Administrator user and a test user ID.  I have patched the server with the most recent CR Server 11 service pack and hot fixes.  These reports run with and without the parameter  on a standalone version of CR 11 which resides on my workstation and a standalone version of CR 11 which resides on the server.  I have spent about 6 hours on the phone with Business Objects without resolution.  Help please!
Question by:cindyfwills
    LVL 16

    Accepted Solution

    are you filling in the parameter with information?  Do you have the defaults set correctly in the CMC, under objects>Process>Parameters? Make sure that if you are using a database connection (not a business view or universe) that you have the option called" When viewing reports" turned to Use same database logon as when report is run.

    Outside of that I am out of ideas.

    Author Comment

    Thank you for your suggestions.  The cacheserver process and two other processes were changed from local server administrator to domain server administrator and these parameter reports are now working!  I believe it must be the way these processes interact with the GUPTA SQL ODBC driver.
    LVL 100

    Expert Comment

    Do you still need assistance?


    Author Comment

    No, my issue has been resolved -- thank you!

    Author Comment

    I awarded the points -- thank you -- please close

    Expert Comment

    Hi cindyfwills,

    I am having the same problem. Everything is running OK on my Windows XP machine. I then put these reports onto my Windows 2003 Enterprise Server and the reports come up with the same error: Failed to open the connection.

    Could you please elaborate on how did you resolve this issue?


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now