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, 2011 at 11:38 PM in Default

avatar image

905 60 64 68

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

2 answers: 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, 2011 at 12:09 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

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, 2011 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, 2011 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, 2011 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, 2011 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, 2011 at 10:23 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

Not quite familiar with the listview in SQL. However, from my experience of C# listview. There are some types of list, like List View Type,Icons View Type and Detail View Type. Maybe solutions will be a little different to the various of vies types.

more ▼

answered Jan 17, 2014 at 07:04 AM

xiaoyuandlg (suspended)
(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



Answers and Comments

SQL Server Central

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



asked: Apr 11, 2011 at 11:38 PM

Seen: 3926 times

Last Updated: Jan 17, 2014 at 07:04 AM

Copyright 2018 Redgate Software. Privacy Policy