Failed to open the connection When Viewing Report On Crystal Server 2011
So you created a report in Crystal Designer 2011 (or whatever other version) and it runs well on your system. You uploaded it to your Shiny New Crystal Reports Server 2011 (BO 4.0, XI4, whatever you call it) and it doesn’t work. You can’t view the report because you get an error:
The viewer could not process an event. Failed to open the connection. My Report - Test 
---- Error code:0 [CRWEB00000119]
com.businessobjects.report.web.shared.WebReportingException: The viewer could not process an event. Failed to open the connection.
Project Request Form Location  ---- Error code:0 [CRWEB00000119]
The Problem is that Crystal Designer is 32-bit, and Crystal Server 2011 is 64-bit.
So if you want to use your report on Crystal Server 2011, you need to add the ODBC connection to the server using the \Windows\SysWOW64\odbcad32.exe ODBC Manager Control panel. After that, your report should run just fine.