Crystal Server Data Connection
Posted on 2011-03-09
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( 184.108.40.2061) and BusinessObjects Enterprise 220.127.116.112 - if that makes a difference.