Troubleshoot reports of slow performance

[ckrusen (Calvin Krusen)]

Might be something useful in this thread:

Very Slow SSRS report (which typically isn't)

I’m working on a custom style of the ARForm report (AR Invoice), and it takes over 10 minutes to run. I opened the report with SSRS Report Builder to see if I can figure out what is going on. But when I click Run, it takes a good 30 seconds before the parameters pane (where you enter the TableGuid) to appear. This makes me think something is messed up in the RDL itself. If it was the RDD alone, I’d expect the TableGuid field to appear instantly, and the processing (after entering the tableGu…