x
login about faq Site discussion (meta-askssc)

How to prevent a report from appearing in the List View

I have a report published to a report server (2008 R2). The report displays in the list view. How can I make the report not appear in the List view?

Note that SSRS has an option "Hide in Tile View" that makes the report not show when in Tile View. But this does not help because users can still see the report in List View.

Note that I also still do want the report to be published to the report server because the report is used by other reports (using Action | Go To Report).

more ▼

asked Apr 11 '11 at 11:38 PM in Default

xnl28 gravatar image

xnl28
765 45 49 56

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

1 answer: sort voted first

The only other way I know to "hide" the report is to have it in a different directory or to change the permissions on the report. I dont have a 2008 R2 server so cannot be sure but you may be able to use a permission to prevent users changing to List view?

more ▼

answered Apr 12 '11 at 12:09 AM

Fatherjack gravatar image

Fatherjack ♦♦
38.8k 55 69 104

If a new directory is created for the report and the permissions set so the users cannot see the directory, then I would expect that the Go To Report action to this directory will not work.

Apr 12 '11 at 04:32 AM xnl28

You can override permission on the report level and then when you call the report directly, it should be accessible.

Apr 12 '11 at 04:43 AM Pavel Pawlowski

Thanks, Pavel and Fatherjack, I did it that way. (Create a new directory called HiddenReports, deploy the report to that directory; set permissions on that directory so that the NT account has no access; then set permissions in the report itself so that the NT account has Browser access.)

This has a couple of drawbacks:

It requires security to be set on individual reports, which is extra maintenance. A better option would be to create another directory below HiddenReports (say, HiddenReportsContents), and grant the NT account Browser access on that directory.

The reports in which the Go To Report action is configured must be hard-coded with the name of the HiddenReports (or HiddenReportsContents) directory.

This sort of messy work-around usually indicates that the system can't handle what is required. I think there is a need for SSRS's security model to have an Execute role that allows a report to be executed. This is different to the Browser role, which controls whether a report or folder is displayed.

Apr 13 '11 at 09:03 AM xnl28

This is what I think is needed:

Browser May see folder and report names. Execute May run reports and subscribe to reports.

Apr 13 '11 at 09:08 AM xnl28

how about logging it as a feature request then? Go to http://connect.microsoft.com and explain your requirement. You never know, if you get enough votes, it could be implemented.

Apr 13 '11 at 10:23 AM Fatherjack ♦♦
(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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x486
x391

asked: Apr 11 '11 at 11:38 PM

Seen: 1127 times

Last Updated: Apr 11 '11 at 11:38 PM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.