Problem with connection when preview Crystal Reports 2013 form in SAP HANA

[PedroMariano]

Hi,

When preview or print layouts created in Crystal Reports in SAP Business One HANA, we are facing the following error:

Fail to open the connection.

In Crystal Reports, when we go to 'Add Ins' in order to preview in SAP we get a impossible to connect to SAP Business One message.

When we preview the layout in inside Crystal Reports, everything works fine.

We are working with:

-Crystal Reports 2013 SP2

-SAP HANA 9.0 PL13.

We tried:

-ODBC 32 bits and 64 bits;

-ODBC driver HDBODBC and B1CRHPROXY for both 32 and 64 bits.

However we when we preview the layout in SAP HANA or in the Add In in Crystal Reports we are facing the connection problem.

Does anyone know how to overcome this issue?

Thanks in advance.

Best regards,

Pedro Mariano

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please post screen shot of above error message from crystal report preview.

Thanks & Regards,

Nagarajan

[PedroMariano · Accepted solution]

Hi Nagarajan,

Thank you for your reply.

I show you the screen shots of the success in Preview in crystal:

The error in preview the addin from CR to SBO:

The error in preview in SBO:

Best regards,

Pedro Mariano

[PedroMariano · Accepted solution]

Hi Nagaranjan,

Are you familiar with the error screenshoots I posted?

Thank you.

Best regards,

Pedro Mariano

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please translate error message in English.

Thanks & Regards,

Nagarajan

[PedroMariano · Accepted solution]

Hi Nagaranjan,

Thank you.

The error in preview the addin from CR to SBO says "Impossible to connect to SAP Business One".

Best regards,

Pedro Mariano

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please check SAP note:

1909638 - CR_Cannot preview Crystal reports or layouts in the SAP Business One client if the databas...

Thanks & Regards,

Nagarajan

[PedroMariano · Accepted solution]

Hi Nagaranjan,

The databasename doesn't start with a number.

In fact, it has no special characters.

Any more hints?

Thank you.

Best regards,

Pedro Mariano

[kothandaraman_nagarajan · Accepted solution]

Please make sure SAP B1 running while preview through add-in.

[PedroMariano · Accepted solution]

Hi Nagaranjan,

SAP B1 is running.

If you notice in my second post (Oct 10, 2014 11:38 AM), the error in preview in SBO refers to the error inside SAP B1.

In English, the message says "Fail to open connection" "Fail to open connection".

Do you know why?

Thank you.

Best regards,

Pedro Mariano

[ivan_leonardo · Accepted solution]

Hi Pedro,

Have u reinstall the CR Integration package ? or Re-install all the CR 2013 ?

[PedroMariano · Accepted solution]

Hi Ivan,

Thank you for your input.

Yes, I already did both action but to no avail.

Do you have more hints?

Thank you.

Best regards,

Pedro Mariano

[PedroMariano · Accepted solution]

Hi all,

Solved after filling the connection string instead of select a data source:

Best regards,

Pedro Mariano