SSRS hide Datasource directory and subreports

Posted on 2011-10-21
Last Modified: 2012-05-12
I wonder if you have solution on how to hide reports, directories in SSR so user could not see, for example, DataSource directory or subreports. I found one side for SSRS 2005
but I could not repeat steps that provided by this article.

thank you for your help in advance!  
Question by:DDB
    LVL 25

    Expert Comment

    You can hide it manually by going to report manager page. There at home directory\page, at the right top corner, you will see list button (the blue color one). On clicking, it will you will get the list view of the folder. Similar thing can be done inside any other folder. Just click the edit button and click the hide check box.
    LVL 3

    Author Comment

    are you talking about [hide in tile view] combo box? it did not work for me. Users still could see subreports. I hided data sources using security tab in report manager. If I do the same to sub report then they could not run main report as well.
    LVL 1

    Expert Comment

    Hy, In web-browser from the right's report corner click "Open Menu" arrow, select "Manage", select "Hide in tile view" by clicking the combo box and then click "Apply". That's it!
    LVL 3

    Author Comment

    I did it but it shown anyway. I am using 2008 r2.
    LVL 3

    Accepted Solution

    the only way to hide the subreport is to put them in separate directory or use security option but in this case user will not see subreport. I wish MS come up with the better solution.
    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. (htt…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    26 Experts available now in Live!

    Get 1:1 Help Now