Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: SQL Stored Proc as datasource Post Reply Post New Topic
Author Message
btamulis
Newbie
Newbie
Avatar

Joined: 02 Aug 2008
Online Status: Offline
Posts: 9
Quote btamulis Replybullet Topic: SQL Stored Proc as datasource
    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!!!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.000 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.