Suhas R. Kudekar: Change the Look & Fill of the Report Manager.

In Previous Blog Architecture Diagram of SSRS post we were getting the completed diagrammatic overview of SSRS Architecture. In that a Web-based report access and management tool is available named as Report Manager.

Definition - Report Manager is a Web-based report access and management tool that we use to administer a single report server instance from a remote location over an HTTP connection. we can also use Report Manager for its report viewer and navigation features.

Different type of Report Manager Properties Available on clicking on diffrent available Tab.

· Site Settings Properties

On the Site Settings page, we have General Properties, Security and Schedule

Report Manager – Data Source Properties with the exception of Dependent Items. Dependent Items page will list all items (reports, data sets) that use this particular Data Source.

· Search Properties

We can now search in SSRS Report Manager! Type in our keyword, and a way we go! It will find your report, your data set, your folder, or even your report part.

· Report Contextual Dropdown Properties

When we hover over a report item and click on the down arrow, we will be able to move, delete, edit in Report Builder 3.0, and explore other properties, to name a few.

· Report Properties

We have links for : properties, data sources, shared data sets, subscriptions, processing options, cache refresh options, report history, snapshot, and security.

· Shared Data Set Properties

Share data sets among diffrent reports.

· Shared Data Set Caching Properties

Cache these shared data sets.

We can use Report Manager to browse the report server folders or search for specific reports. we can view a report, its general properties, and past copies of the report that are captured in report history. Depending on your permissions, we might also be able to subscribe to reports for delivery to an e-mail inbox or a shared folder on the file system.

How we can Start Report Manager

ü To start Report Manager from a browser Open Microsoft Internet Explore

ü In the address bar of the Web browser, type the Report Manager URL.

By default, the URL is http://<ComputerName>/reports.

ü The report server might be configured to use a specific port. For example,

http:// <ComputerName>:80/reports or

http:// <ComputerName>:8080/reports.

Change Bascic look & fill of Report Manager

To change the top area color in Report Manager, please refer to the following steps to achieve this:

1. Navigate to ReportingServices.css file.

Path: <Drive:> \Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\Styles

2. If want backup the ReportingServices.css file before you modify it, open it with notepad format.