I found the answer.


Temp Tables Cause SSRS not to Populate Fields
Posted by Adam Rink at 7/19/2007 and is filed under SQL Server Reporting Services - SSRS
If you use stored procedures that contain dynamic SQL or temp tables, you know the frustration with SSRS not detecting the field names automatically for the report. The reason for this is because SSRS does not run the stored procedure to get the output and...

I need to clarify this request. I have a script that works as a TSQL query that writes to a #tmp table. But I need to port this TSQL Script to SSRS and just copying the script to SSRS Report wizard does not work . I will post the code and the error. The error relates to using a TMP Table. ERROR: There is an error in the query. Invalid object name '#tmp'. I get this from the SSRS Design the query wizard. If I just enter the code and run it...

Thanks for you help in advance. I am trying to use sp_helpdb to get the size of all the databases on a sql server. The results of sp_helpdb (when using the @dbname='databa sename') is 2 sets of data. The first iset s the results I want and the second set is the information about the files. While this second set of information is valid and relevant I don't want the second set for this query. So. Below is my code. You can see that I am parsing...