Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

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.
0
lcallah93
Asked:
lcallah93
1 Solution
 
GJParkerCommented:
that any data sources you choose when building your Data Connections are also installed on the BusinessObjects Enterprise servers'

What this is saying is make sure that any ODBC connections used in your report/ business views are creatd on teh BO servers.

HTH
0
 
lcallah93Author Commented:
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
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now