x

Why can't a user see SSRS report on Report Manager?

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.
more ▼

asked Oct 05, 2012 at 02:39 PM in Default

susanc gravatar image

susanc
80 4 4 4

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.
Oct 05, 2012 at 03:12 PM susanc
Have you checked the executionlog table,, there is stats in there that give you the query execution time and render time fir that report
Oct 05, 2012 at 09:19 PM sp_lock
Only this particular user? Can you double-check with a different account? Same behaviour?
Oct 08, 2012 at 09:12 PM DirkHondong
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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?
more ▼

answered Oct 05, 2012 at 02:48 PM

Fatherjack gravatar image

Fatherjack ♦♦
42.4k 75 78 108

(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Oct 05, 2012 at 02:49 PM

BarneyL gravatar image

BarneyL
62 1

(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Oct 11, 2012 at 03:45 AM

happycat59 gravatar image

happycat59
10

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x547

asked: Oct 05, 2012 at 02:39 PM

Seen: 1475 times

Last Updated: Oct 11, 2012 at 03:45 AM