Skip to Content
avatar image
Former Member

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?

SAPCR.png (33.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 28, 2014 at 03:00 PM

    Thank you all, I found a tempral solution (while the fix patch releases on PL 12):

    1. Create a blank report
    2. 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)
    3. 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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2014 at 12:36 PM

    Hi Amilcar,

    SAP note 1966445 - CR_Cannot display SAP Business One company databases when creating a new connection confirms this is an application error.

    I have been told this is planned to be fixed in PL12 which is the next patch to be released.

    Kind Regards,

    Nick Lakasas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 26, 2014 at 02:15 PM

    Hi Amilcar,

    CR 2011 doesn't support SQL Server 2012.

    CR 2013 is supposed to support SQL Server 2012. Have you tried to reinstall the PL9 integration component? Available in the product package: Packages\CRAddins\....exe.

    Best

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Amilcar,

      First thing is SAP Business One didn't support CR2013 until 9.0 PL09. Do you install the CR 2013 FOR SAP BUSINESS ONE? Sorry that I presumed that you installed the standard version instead of the OEM version in my previous reply (deleted)

      And did you install the PL09 integration?

      Regards

  • Apr 27, 2014 at 06:36 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2014 at 10:55 AM

    hi

    you can use the OLE DB connection it will work

    shachar


    oledb.gif (47.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 28, 2014 at 01:11 AM

    Hi,

    Yes it is an application as replied by Mr. Nick Lakasas. Try with work around stated in above note.

    Current PL for 9.0 version 11.

    Thanks & Regards,

    Nagarajan


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2014 at 01:44 AM

    Yes Nick is right. I forgot that Note...

    Regards,

    San

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2015 at 05:55 AM

    In my case the solution was to install the DI API 32-bits version.

    I had installed everything in 64bits version.

    After installing the 32-bits version, I could select the company database in the sap one connector. Before I did, the drop down list was empty.

    Another caveat: For the server you might have to provide the instance name as well as the hostname of your SQL server. It depends on whether you have installed SQL server as an instance or as a named service. So thats: SVRDB\INSTANCENAME in my case for servername.

    Add comment
    10|10000 characters needed characters exceeded