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

avatar 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

avatar image

Fatherjack ♦♦
43.7k 79 98 117

(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

avatar 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

avatar image

happycat59
330 2 1

(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.

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:

x650

asked: Oct 05, 2012 at 02:39 PM

Seen: 2446 times

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

Copyright 2016 Redgate Software. Privacy Policy