nick947 (8/21/2013)
I am having an issue with one of my reports. When I run the report in BIDS 2010 there are no problems, the report runs in a few seconds. However, once I deploy it to our server running SSRS 2012 I run the report and loading animation is the only thing that shows for over 10 minutes before I close my window. I thought at first this might be an issue with parameter sniffing, so to combat that I used the recompile hint and temporary variables in the stored procedure. I am out of ideas of what this could be. Any help would be appreciated.
Have you queried the ReportServer.dbo.ExecutionLog to see if it is the TimeDataRetrieval that's way out of wack?
I just recently had run into a similar problem and it turned out to be a param sniffing issue -- it sounds you've already went down that path though.
Good luck,
Rob