http://blogs.msdn.com/b/bwelcker/archive/2007/01/05/the-destroyed-room-hyperion-essbase-and-reporting-services-white-paper.aspxOne of the new Reporting Services features of SQL Server 2005 Service Pack 2 is integration with the Hyperion Essbase 9.3 . Similar to building reports on SQL Server Analysis Services or SAP NetWeaver BI , this integration includes a new .NET data extensionen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/bwelcker/archive/2007/01/05/the-destroyed-room-hyperion-essbase-and-reporting-services-white-paper.aspx#1481357Wed, 17 Jan 2007 06:20:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:1481357bkdotnetguy<p>Hi,</p> <p>i cannot find the answer anywhere. Can you use stored procedures with experssion based connection string in reporting services 2005?</p> <p>It works fine with ad-hoc plaint text sql but not with stored procs</p> <p>Please help!</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=1481357" width="1" height="1">