Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1830
  • Last Modified:

SSRS hide Datasource directory and subreports

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 http://www.mssqltips.com/sqlservertip/1357/show-and-hide-reporting-objects-in-sql-server-reporting-services/ 
but I could not repeat steps that provided by this article.

thank you for your help in advance!  
0
DDB
Asked:
DDB
1 Solution
 
TempDBACommented:
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.
0
 
DDBAuthor Commented:
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.
0
 
iosifsCommented:
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!
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
DDBAuthor Commented:
I did it but it shown anyway. I am using 2008 r2.
0
 
DDBAuthor Commented:
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.
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now