Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: linking stored procedures to views Post Reply Post New Topic
Author Message
lennis
Newbie
Newbie


Joined: 02 Aug 2007
Location: United States
Online Status: Offline
Posts: 1
Quote lennis Replybullet Topic: linking stored procedures to views
    Posted: 02 Aug 2007 at 11:42am

I have a report that was created and utilizes several views.  The views are linked by inner joins on a unique identifier field type.  I need to add a stored procedure to the report, and the stored procedure needs to be linked by a left outer join to the last view in the linking.  The stored procedure is  linked on a unique identifier field type back to the view.

 As soon as I link the stored procedure, the report begins to function strangely.  Only a couple of the records are returned and appear linked.  Does anyone know of any issues with linking stored procedures to views in a report, or with linking on unique identifiers.

I am using Crystal Reports 11.5 release 2.  Any assistance would be greatly appreciated.

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 02 Aug 2007 at 9:48pm
Ideally, you should be fine. I have to wonder what it's doing behind the scenes processing all the views and trying to join them. I would try to recreate the structure one step at a time. First use the stored procedure with the closest joined view. See how that does and then add another view. By breakiing it down like this you might find which join is causing the problem.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.016 seconds.