Is it possible to create a report using the report wizard that will return the results from a Stored Procedure that contains a temporary table?
I have tried this but I get an error message at the "Design the Query" stage of the Wizard......
"There is an error in the query. Invalid object name '#Temp'.
I also get the same message if I try to display the estimated execution plan in Query Analyser.
Thanks in advance,