x

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
895 54 58 61

(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 '11 at 12:09 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.2k 72 77 107

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

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 at 07:04 AM

xiaoyuandlg gravatar image

xiaoyuandlg
311

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

x562
x535

asked: Apr 11 '11 at 11:38 PM

Seen: 1865 times

Last Updated: Jan 17 at 07:04 AM