Sql reporting service wizard does not have a permission to access temp tables created in other sessions.Use 'Declare @Temp Table' instead of create statements.