asked on

Crystal Server Data Connection

I am having a few issues with getting Crystal Reports to play nice with BusinessObjects Enterprise but I think I have narrowed it down (at least I hope) to the following:

1) When creating the report from a Business View I received the following error when trying to View in the CMC - 'Failed to Open Data Connection'. I found the following in the Crystal 2008 reference book but do not know how to accomplish this task 'Ensure that any data sources you choose when building your Data Connections are also installed on the BusinessObjects Enterprise servers (Report Job Server, Page Server, Report Application Server, List of Values Server)' - I assume this is why I am receiving this message? I have created the entire BV from scratch twice to make sure I didn't change anything mid-stream that might have affected the connection.

2) I can save LoV/DCP reports created entirely from Business Views as well as created from non-Business Views but with Business View generated LoV/DCP. However in the both cases the lists are completely blank at run-time. Is this related to issue 1?

I think that's it (for now).

I am running Crystal Reports 2008 SP 3( 12.3.0.601) and BusinessObjects Enterprise 12.1.0.882 - if that makes a difference.

ASKER CERTIFIED SOLUTION

GJParker

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

lcallah93

ASKER

Thank you - once I verified the DSN connections on both the cilent and server were mirrored exactly everything worked. I also figured out from reading other posts as well as trial and error that 'use single sign on when viewing' must be set to False - that did the trick for the LoV and DCP issues.

Lisa