Print Page | Close Window

linking stored procedures to views

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=1107
Printed Date: 05 Apr 2025 at 7:40am


Topic: linking stored procedures to views
Posted By: lennis
Subject: linking stored procedures to views
Date 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.


Replies:
Posted By: BrianBischof
Date 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>


Print Page | Close Window