Skip to Content
0
Former Member
Aug 01, 2007 at 06:02 PM

Linking stored procedure to a view on a unique identifier field type

13 Views

Post Author: lennis

CA Forum: Data Connectivity and SQL

I have a report that was created and utilizes several views. The views are linked by inner joins on a unique identifer 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 also 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.and appear to be linked. Does anyone know of any issues with linking stored procedures to views in a report?