Referring to Fast query runs slow in SSRS my scenario is 1 row, 97 columns (I know a lot of columns - I can change the parameters to get more rows) also 9 parameters, I had a select statement calling a multi statement function so I tried moving to a proc but still calling the function made no difference, tried all the optimize options to avoid parameter sniffing, still makes no difference. The function or proc runs in 2 seconds in production a little slower in 2 other test environments. The SSRS report runs in about 6 to 40 seconds in the other environments, within Visual Studio like 40 seconds the first time you run then if you click the refresh button 6 seconds however PROD 20 to 30 mins yes heard me right minutes.

I know some of you are going to say you idiot reduce your number of columns, move your code out of the function into the proc (I would like to but the function is shared across other reports) or upgrade your SSRS and Visual Studio (it is coming trust me in was recorded in Jan 2012 in the things to do log book). Barring those suggestions anything else I can try?