SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Error: Invalid object name '##Report'. (Microsoft
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vikramsinh
Starting Member

India
4 Posts

Posted - 05/23/2009 :  09:22:36  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 05/23/2009 :  11:31:49  Show Profile  Reply with Quote
its a non issue. it sometimes complains about temporary tables in data tab but on clicking ok it will work fine.
Go to Top of Page

usman531
Starting Member

2 Posts

Posted - 05/24/2009 :  16:45:06  Show Profile  Reply with Quote

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

Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 05/25/2009 :  00:37:32  Show Profile  Visit nr's Homepage  Reply with Quote
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.

Edited by - nr on 05/25/2009 00:38:33
Go to Top of Page

rlevine
Starting Member

USA
2 Posts

Posted - 12/05/2013 :  19:54:13  Show Profile  Reply with Quote
I was having the same issue and this solution as worked well for me.

Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000