Print layout error, Crystal Report with store procedure on SAP Business One HANA

[douglas_marroquin]

T

Hello Everybody,

This my first Crytal Print Layout on SAP Business One Hana.

I am trying create a Print layout with Crystal Report on SAP Business One HANA 9.2

I upload the rpt file on SAP Business One, but when I need check the preview shown this message error:

The table 'FACTURACION_SP' could not be found. Error in File INV20010 {c47a5467-3975-4e10-b860-4795fbbe791d} 400_3580_{182BF275-ACA2-4470-8751-A6FC8F35BFAA}.rpt: The table could not be found.

these are the steps that I done:

1- Create a store procedure on Schema DataBase

2- Deploy store procedure

3- Create a system DSN

4- Create a rpt file linked to store procedure (in this step all is ok, I can view the data)

5- Import the rpt file to SAP Business One.
Thank you for your help.
I attach the pictures files, describing all steps.

[Former Member]

Not sure how SAP works, but taking SQL server as an example I create the SP in SQL Management Studio and ensure that view/execute rights are granted to the report user login credentials from Management Studio.

Ian

[Former Member]

Have you granted rights to the SAP Business One user account to see/execute the SP.

Ian

[douglas_marroquin]

Hello Ian,

I used manger account in SAP Business One, Where configure see or execute SP?

Thank you.

Kind regards.