SQL Server Reporting Services :: Queries Using Temporary Tables
Argh; SQL Server Reporting Services don’t support queries and/or stored procedures using temporary tables.
Reporting services is very scalable platform; one can implement custom data source provider; I think the above problem is specific to the SQL Server data source provider that is bundles with the SQL Reporting Services. One might try to implement his own data source provider.
But for the time being; I have modified my stored procedure!