<div>
Thanks ABaruh,<br />
<br />
Please could you point me to some resources that will explain how I to do this?<br />
<br />
Thanks.
</div>


Thanks ABaruh,

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

Thanks.

<div>
When you open a new project in Visual Studio, you have two choices: <br />
<br />
Report Project Wizard<br />
or<br />
Report Project<br />
<br />
choose the latter.
</div>


When you open a new project in Visual Studio, you have two choices:

Report Project Wizard
or
Report Project

choose the latter.

<div>
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. &nbsp;That should be worth getting the solution points.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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?<br />
<br />
I have tried this but I get an error message at the &quot;Design the Query&quot; stage of the Wizard......<br />
<br />
&quot;There is an error in the query. Invalid object name '#Temp'.<br />
<br />
I also get the same message if I try to display the estimated execution plan in Query Analyser.<br />
<br />
Thanks in advance,<br />
Steve.<br />
<br />

</div>
</div>


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.



SQL Reporting Services - SP with Temp Table

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.