Have an SSRS I created in VS 2008. SQL server = 2008r2, authenticated login with my domain credentials.
The report I have has about 12 or so TableX controls on it with various queries to produce a summary report of activity.
Everything was fine when I left yesterday, however, when I came in this morning, the report just hangs when I click "preview" (or run the report in debugger). All I see is "report is being generated" and then I have to go into task manager and kill devenv.exe to recover from it.
Inside the report designer I've ran each query individually to verify that there are no "long running" queries and there arent. Each take about a second to return results. Other reports in the package run fine, just this one is an issue.
Is there someplace I can look or do I have to start deleting TableX's one by one to find the culprit (if thats even the problem).
Thanks
Frank
Best Answer
Time to put my comments into an answer (even though you've already tried some of 'em). You ask for methods to find out which part of a report is tripping up execution, here's my 2 cts.
First things you can try when you're stuck:
If you want to dive a little deeper and have access to a true reportserver:
Some additional things that may help:
TOP 10
or something similar in all your queries to find out which one is causing trouble.Failing all that I think your best option is the one you already mention: find the offending tablix and query by process of elimination.
As a final thought, the two things that caused 99% of our performance problems in SSRS:
Hope this was helpful to you or any future visitor. If not be sure to answer your own question here and tell us how you solved things in the end.