AnsweredAssumed Answered

Crystal report based off a universe fails: Failed to open connection.

Question asked by deepud on Jan 29, 2013
Latest reply on Jan 30, 2013 by Rajini
Hi Experts,

Using BOE 3.1 SP5..

1. The crystal report published to BOE uses a Universe.
2. This universe's connection uses an ODBC connection. No issues with ODBC connection. Universe Connection in Universe designer has been tested successfully.
3. The report runs fine in CR designer.
4. Things go wrong after the report is published to BOE.
5. Here is how the db configuration of the report looks just after publishing. Se attached image.
6. Running the report as per information in BOX 1 fails expectedly as the nikuv12 is not the user specified in the Universe's connection.

7. As per my understanding the changes to be done to BOX 2 should be to ...
a. Specify correct User and Password. Doing this does not help either.
Is step (a.) correct? Am i missing something?

Please help!