Jan 26, 2017 at 12:29 AM

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

536 Views Last edit Sep 04, 2017 at 08:02 AM 2 rev

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.

Attachments

step-1-store-procedure.png (40.6 kB)

step-1-2-create-store-procedure.png (38.1 kB)

step-1-3-check-store-procedure.png (64.2 kB)

step-2-2-execute-store-procedure.png (29.0 kB)

step-3-1-print-layout.png (89.0 kB)