Monday, October 3, 2011

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.
3.      Change the following portion in ReportingServices.css file:

Original Available - table.msrs-header { background-color:#fff; }

After Changed - table.msrs-header { background-color: #f00; }

This way we can change the Look & Fill of the Report Manager.

Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)
Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2


1 comment: