Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 26, 2017 at 11:01 AM

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

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2017 at 09:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded