Error: Invalid object name '##Report'. (Microsoft

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Error: Invalid object name '##Report'. (Microsoft

Author

Topic

vikramsinh
Starting Member

4 Posts

Posted - 2009-05-23 : 09:22:36

hi all,
i am developing reports using ssrs
i am using BI project for develop this reports ,
i write query in query string of dataset as follow

exec [HSI].[usp_RaguTest_Reports] @year

but once i click on the OK button it give me followiong error

Invalid object name '##Report'. (Microsoft SQL Server, Error: 208)

please help me out to solve this problem

thanks
Vikram

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-23 : 11:31:49

its a non issue. it sometimes complains about temporary tables in data tab but on clicking ok it will work fine.

usman531
Starting Member

2 Posts

Posted - 2009-05-24 : 16:45:06

Hi Vikram
i was having the same problem because i was using the Temp table in my report store procedure when i give the store procedure report i click the refresh button it ask me parameters then i execute button now it is ok. you can try in this way

regards
Usman

quote:
Originally posted by vikramsinh

hi all,
i am developing reports using ssrs
i am using BI project for develop this reports ,
i write query in query string of dataset as follow

exec [HSI].[usp_RaguTest_Reports] @year

but once i click on the OK button it give me followiong error

Invalid object name '##Report'. (Microsoft SQL Server, Error: 208)

please help me out to solve this problem

thanks
Vikram

nr
SQLTeam MVY

12543 Posts

Posted - 2009-05-25 : 00:37:32

Are you sure you want to use ##report? That is a global temp table which means the report can only be run once at a time.

If I use temp tables in reporting SPs then I usually include as the first statement a dummy select to give the report format.

if 1=0
select col1 = 1, col2 = convert(varchar(20),''), ....

The report will look for the first select to give the daatset format (which is why a temp table will mess things up).

Sometimes I will run the SP to create an empty table and do the select from that instead.
if 1=0
select * from s_myreportsp_format

...

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

rlevine
Starting Member

2 Posts

Posted - 2013-12-05 : 19:54:13

I was having the same issue and this solution as worked well for me.

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources