SQL Reporting Services - SP with Temp Table

Hi,

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,
Steve.

ive5005sAsked:
Who is Participating?
 
ABaruhCommented:
Can;t use the Report Wizard.  You have to create the report without using the wizard, meaning you have to manually define all of your fields.
0
 
ive5005sAuthor Commented:
Thanks ABaruh,

Please could you point me to some resources that will explain how I to do this?

Thanks.
0
 
ABaruhCommented:
When you open a new project in Visual Studio, you have two choices:

Report Project Wizard
or
Report Project

choose the latter.
0
 
ABaruhCommented:
I did answer his question about why he was getting the error message - you cannot use the Report Wizard if the SQL stored proc in the dataset has temp tables.  That should be worth getting the solution points.
0
 
ive5005sAuthor Commented:
Thanks ABaruh.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.