question

DataArtist avatar image
0 Votes"
DataArtist asked Isabellaz-1451 edited

Report folder structure for hosting SSRS reports should be driven by department or Data domain ?

I have a bunch of reports which are just dumped on a report home folder . I would like to organize them hence want to know from Microsoft if I need to follow any specific design principle and naming standards to manage the reports plus should I group them based on domains or departments? What is considered best practice today?

sql-server-generalsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Isabellaz-1451 avatar image
1 Vote"
Isabellaz-1451 answered Isabellaz-1451 edited

Hi @DataArtist ,

My suggestion to you is that you can group by department, and then grant each department access to its own department folder, so as to ensure the security of information.

There are two types of roles: Item-level roles and System-level roles.
The Item-level roles are used to view, add, and manage report server content, subscriptions, report processing, and report history. We can assign Item-level roles on the root node (the Home folder) or on specific folders or items.
For example: You grant the domain user group (in this case USERS\USERS) permission to the "Home" folder inside SSRS. when a given user hits the SSRS web interface (typically http://<ssrs_server_name>/reports), they will be prompted to enter their windows credentials. once they do that they will be allowed access to the home folder. you set up folders inside SSRS with varying levels of permission per user from there.

If you want the user has less permission ,You can fine-tune the permissions of a given windows login from there by logging into the report server using SSMS, and looking at "Roles". For example you can adjust the "Browser" role to only be able to run a published report. they can't even open the properties of the report. Then grant additional access where necessary.


You may refer to this thread who has the same issue as you :
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fda44087-d4d8-4917-a572-3126dabbd7d0/organizing-reports-in-ssrs-folder-tree?forum=sqlreportingservices


Best Regards,
Isabella


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.