SAP Crystal Reports 2011/2013 doesn't show Company Data Base
I have CR versions 2011 and 2013 in several clients, and I can't connect to SAP B1 through the integration component. The behavior is that when I fill all the fields, I can't see the Company DataBases; if I type it manually and click "finish" I get the "conexion failed" error. With version 2011 it was working and then stoped working just like that. With 2013 has never worked. I've read in several forums that this error is recognized by SAP since early 2008 versions, but only talk about future "fixes". I've checked if any fix for 2013 is available but no lucky, it seems that fixes is a mess with CR.
See screenshot. Any ideas how to fix this? is this really a bug?
I have SAP 9 PL 9.
UPDATE: My SAP Partner Support has told me this error is caused by the version of SQL I have (which is 2012) and that SAP will release a patch to correct this soon, is this correct?
Thank you all, I found a tempral solution (while the fix patch releases on PL 12):
- Create a blank report
- Use the SAP complemente to "save" the report; this will make you create a conexion to SAP. Aftetr that you can cancel saving the report (you can avoid it)
- After this, create a new data origin (DataBase>Data Base assistant) and this time you will be able to see the company data base.
Hope this is useful for anyone else with the same problem