Skip to Content
0

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

Jan 26, 2017 at 12:29 AM

179

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ian Waterman Jan 26, 2017 at 11:01 AM
0

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

Ian

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Ian,

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

Thank you.

Kind regards.

0
Ian Waterman Feb 07, 2017 at 09:17 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded