다음을 통해 공유

Change the Look & Feel of the Report Manager

  • 아티클

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.

http://4.bp.blogspot.com/-jQs-zG-SLu8/TomuUI0cNYI/AAAAAAAABQc/G4ebinTpSLs/s400/SSRS1.png

Different type of Report Manager Properties

Available on clicking on different 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 different 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 Explorer

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

**Change basic look & feel 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 you to 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 - Report Manager Page

http://4.bp.blogspot.com/-jQs-zG-SLu8/TomuUI0cNYI/AAAAAAAABQc/G4ebinTpSLs/s640/SSRS1.png

After Changed - Report Manager Page

http://2.bp.blogspot.com/-sPbpTyNvTuM/TomurNzKVbI/AAAAAAAABQg/mtJJdcC1qrQ/s640/SSRS2.png

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