[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Reporting Services - SP with Temp Table

Posted on 2005-05-05
6
Medium Priority
?
535 Views
Last Modified: 2012-06-22
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.

0
Comment
Question by:ive5005s
  • 3
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
ABaruh earned 600 total points
ID: 13942625
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
 

Author Comment

by:ive5005s
ID: 13950418
Thanks ABaruh,

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

Thanks.
0
 
LVL 7

Expert Comment

by:ABaruh
ID: 13963407
When you open a new project in Visual Studio, you have two choices:

Report Project Wizard
or
Report Project

choose the latter.
0
 
LVL 7

Expert Comment

by:ABaruh
ID: 14203846
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
 

Author Comment

by:ive5005s
ID: 14203869
Thanks ABaruh.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question