Reporting Services - use of temp tables

Hello all,

I need to create a report based on a stored procedure. This stored procedure contains temp tables. At the time of creating the report, I receive a message mentioning - There is an error in the query. Invalid object name '<temp table name'>

Doesn't Reporting Services support temp tables?

Thanks all,
SauravYou can use temporary tables. I tend to do it like...

-- Create temporary tables
declare @.MyTempTable table
(
field1 int,
field2 smalldatetime,
field3 int,
field4 smallint
)

You can then use @.MyTempTable for your SP.

Hope that helps.sql