Skip to Content
0
Jun 25, 2018 at 07:10 PM

Crystal 2016 ans SQL Server Stored Procedure

303 Views

I have written a SP in SQL 2008 R2 which has input parameters and will return one scalar value as well as do some table updating. I can run the SP in the management console just fine. But, I need to incorporate this SP into a Crystal Report. I can add this SP in the Database Expert but I cannot click on the plus sign to expand the SP to get at the return value and add it to my report.

I've been working with computers for a long time but am new to SQL server and am not familiar with roles and security settings so it maybe something fundamental. Also, my last encounter with Crystal Reports was in 1997.

Anybody know what I may be doing wrong?

TIA - Chris