I developed a report with BIDS which uses a stored procedure on MS SQL 2008 Database to populate its dataset used as Datasource. The report runs very slow (10 mins) and if the stored procedure is executed separately on MS Server Management Studio (SMS) it takes only a few seconds with the same parameters. Appreciate if anyone could help on this issue. Thanks. VisaAde

Even I am facing the same issue, but in my case it is not an SP rather an MDX query.

Is that possible parameter sniffing? Add option with recompile to the queryBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Seems you need to add SET FMTONLY OFF to your procedure. Check this thread http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/d46a859f-8635-4ff7-b006-e52ce58252a6/ Regards 'Dotun

Worked. Great. Thank you. Report now very fast.