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


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

Posted on 2006-05-17
Medium Priority
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

wykabryan earned 2000 total points
ID: 16703188
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

ID: 16703327
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 101

Expert Comment

ID: 16705555
Do you still need assistance?

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.


Author Comment

ID: 16705560
No, my issue has been resolved -- thank you!

Author Comment

ID: 16705652
I awarded the points -- thank you -- please close

Expert Comment

ID: 16879839
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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. …
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 …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

867 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