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.