Report Not Responding Upon Opening

[kshen]

Hi all,

I am currently experiencing a isssue that the report was not responding after it was loading the data upon opening. I used the direct query mode. I have checked the sql server database it connected to and all queries were running with no problem. I also checked the other reports using the same database with direct query mode and also they appeared working well. Is there any other method potentially helping me out?

Thanks

[lbendlin]

Check the query duration for each of the visuals on your reprt page. If you can identify the culprit check the query and look for excessive number of records in the query plan.  Refactor the participating measure(s)