What is reporting server and what all elements are found inside a report server?

Problem: What is reporting server and what all elements are found inside a report server?

Solution: Report Server (Share​Point Mode)

Report Server is the centralized place where all the reports get deployed from the reporting project.

Report server is a URL from where users can access reports without going through the designer and can run with AD group permissions and security permissions based on report access.

As most of the reports created are for persons who can run the queries or create reports and to give them access the reporting server plays vital role to get the reports with a simple click from wherever they are.

You can locate the reporting server url from Reporting server configuration manager to see where the reports are deployed.

Things we can do from report server.

1.       Upload a Report RDL file for users to access.

2.       Create user groups to access the reports based on groups. For ex: sales team, hr team, admin team.

3.       Create subscriptions to deliver reports to concerned people on a schedule basis.

4.       Create filtered report access by creating dataset level permissions.

5.       Creating Shared Data sources.

6.       Managing Report permissions.

Example:

In this article, I am going to show we can give permissions to specific reports to specific group of people or person.

Step 0: Open any browser and run as administrator by right clicking on the browser.

Step 1: go to the reporting server using the url from reporting server configuration manager. and select the folder properties to get the options and there will be drop down to provide security options.

 

Step 2: In the next dialog you will get the item security as highlighted. click on it.

Step 3: After clicking the edit item security you will get an option to create new role assignment.

Step 4: in the new role assignment you can enter username or group name to give permissions and select one or more roles to the user/ group.

Step 5: enter the name to create and user to give permissions.

Results:

as you can see the new role has been added to the report server project.