October 31, 2008 at 11:07 am
We've been using SSRS 2005 for a couple years, and I have always had some questions that I can't ever seem to find a good answer to.
Our local setup basically has our users viewing reports in one of two ways:
1. The web client (http://[Server Name]/reports) to view and run reports
2. From within our applications by using a direct URL for the report with all parameters hidden, etc
We separate the different reports by placing all our direct reports in a folder called "Internal". The problem we seem to be having is that we'd like to hide the Internal reports from a user who is navigating the web client. I've looked into hiding the reports, but the users browsing the report server are the same users who call them directly from the application. In the meantime we have created a report list on a Share Point server that just has links to the reports on our report server.
I'll also add that I'd like to start adding an Administration section to the server to get some reports about server performance, jobs, etc. I'd definitely like to keep those reports away from the business reports.
My question is this - is there an easy way to keep these 2-3 sections separate from each other? I was thinking there might be a way to have these reports all live within their own "hive", but be on the same server. I'm not sure if this is possible or if I should really look more into user permissions to hide sections from users. I don't want to install multiple copies of SSRS on the same machine - it's a production box and I think this is too much overhead for what I'm trying to accomplish.
I'm open for any suggestions, and happy to discuss our layout more if you think we have done something fundamentally wrong.
Thanks for your time. - jj
October 31, 2008 at 1:32 pm
I don't know that there is a way to do what you want because you need the users to have permissions on the "internal" reports so as long as they are on the report server they can be browsed.
As far as Adminstrative reports, you could restrict that using the RS security model, by only allowing specific AD users/groups access to the folder. I have worked in shops were that is how they did it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 5, 2008 at 10:40 am
Thanks for your time. I guess we can just continue going the way we've been going. I suppose allowing users to see internal reports isn't the end of the world 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply