|
I have a user that has permission to view reports via Report Manager. He has permissions to run reports in a few folders but when he tries to runs reports in one specific folder, which he has been able to in the past, the screen will display "Loading" but the report will not display. He does not get an error of any type, the report will not display and he has a blank, white screen. I removed the folder, re-deployed and verified his permissions but it still does not work. He is able to run reports from other folders and that is what is puzzling me; his permissions are the same on all folders. Has anyone ever had an issue like this? I have been researching but can't find an answer.
(comments are locked)
|
|
You say he has been able to in the past - something somewhere has changed. If you locate that then you will resolve this issue. I'd say it is permissions, either on the SSRS side or on the database side. Has his AD group membership changed, have there been changes to table, view, stored proc, database security? Does the "Loading" appear after run clicks the report title? I.E. He has permission sufficient to see the report name in Report Manager and open it?
(comments are locked)
|
|
Is he using Google Chrome? That's the usual cause of this behaviour for us. If he is he'll need to switch to another browser.
(comments are locked)
|
|
Get the user to logon to a different PC and run the report from there - this should rule out security/permissions as being the problem. I suspect that this is being caused by something on the user's PC - I have seen something like this in the past but have not been involved in it's resolution (not actually sure whether the problem was resolved, to tell you the truth) If possible, try a different brower on the user's workstation.
(comments are locked)
|
He is using IE. He is able to see all folders created and report names within the folders. Example: when he selects a report in folder a the report will run but when he selects a report in folder b the report will go through "loading" but not appear on the screen. His permissions are set the exact same on each folder and each folder uses the same shared data source.
Have you checked the executionlog table,, there is stats in there that give you the query execution time and render time fir that report
Only this particular user? Can you double-check with a different account? Same behaviour?