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)
 table variables in proc Report not showing

Author  Topic 

BendJoe
Posting Yak Master

128 Posts

Posted - 2010-04-13 : 18:58:05
I am using table variables in my proc it runs in SSMS but the report that uses it never shows data.
Any Fix for this.

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-04-13 : 19:04:29
Are you sure the report is calling the procedure with the correct parameters? Are you sure the report is using the output correctly?

------------------------------------------------------------------------------------
Any and all code contained within this post comes with a 100% money back guarantee.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-13 : 20:51:18
Reports don't care what's in a stored procedure, so it's not the table variable that is causing it. If executing the procedure in SSMS works, then the problem is with your report (either the report itself or how you are calling it).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -