Print Page | Close Window

SQL Stored Proc as datasource

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13951
Printed Date: 22 Apr 2025 at 4:03pm


Topic: SQL Stored Proc as datasource
Posted By: btamulis
Subject: SQL Stored Proc as datasource
Date Posted: 02 Aug 2011 at 10:03am
I have a crystal report constructed in V8 that uses SQL Stored Procedure.
 
I need to convert this report to Crystal XI and change datasource.
 
When I choose my new datasource - I see my sql stored procedure and I click update......I get prompted for parameters which I complete and then click update.........I then get an error message - very generic - unable to connect type message.......
 
Any guidance would be appreciated.......... 


-------------
Thanks to all who contribute to this forum!!!


Replies:
Posted By: hilfy
Date Posted: 02 Aug 2011 at 11:50am
There have been a lot of changes in Crystal since V8, so I suspect that your stored procedure might need to be updated too.
 
Check the stored procedure.  There needs to be one parameter that returns a cursor with your result set.  In the stored procedures I've worked with, this has always been the first parameter in the list.  I don't remember if SQL Server has this, but in Oracle it has to be an "IN OUT" parameter, not just "OUT".
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Emir_W
Date Posted: 05 Sep 2011 at 11:28pm
we used SQL Stored Procedure for our reporting using CR XI.
and most of them using params and it work fine.

have you tried to verify the report?
make sure the params in SP also appeared in CR params (including the sequence).


hope it help.



-------------
Emir W


Print Page | Close Window