I am trying to use the results of a Store Procedure in a Live Report. Using a straight query with the live report works fine, but when I use my stored procedure the report says there are 0 items returned.
The stored procedure performs several queries on its own, combines the results into a temporary table, and then selects the data out of the temporary table. The results of the last select is what should be returned to the Live Report.
If I run the stored procedure from the query analyzer it returns the expected results. If I run the save statement from the live report I get no results returned, and no error messages.
Can someone point me in the right direction and assist? What am I missing?
Livelink is 9.7.1, Database is MS SQL Server 2005.
