failed to retrieve data from the database crystal reports 2008 in SAP B1

[Former Member]

Hello friends,

I am using Crystal report 2008 with SAP B1 PL 8.8. When I run any report, it runs correctly from Crystal Report. But whenever I try to open the same report through SAP ( Tools -> Preview External Crystal Report ), it prompts the parameters for that report and then open up the crystal report window and throws an Error message ("failed to retrieve data from the database. Details [Database Vendor Code: 156]").

Please any one suggest me the corrective solution.

Thanks in Advance,

Keyur Raval.

[Former Member · Accepted solution]

I had the same problem in SAP B1 2007. Report worked fine except when it was open from B1. Generally there may be different problems. In my case the same problem was caused by using some procedure which was in a specific schema. Changing the schema into "dbo" solved the problem.

Radoslaw Blaniarz

[former_member11696]

Post your question to the B1 forum.