Customize Reporting Manager Default Web Site

We can customize a reporting manager default website look and feel (CSS) and so on. We will learn the following points.

  1. Hide Export option from report viewer.
  2. Add banner in report server website.
  3. Hide Data source folder and Dataset folder.
  4. Hide detail view button from reporting server default website.

Let's start from the first point.

1. Hide Export option from report viewer

In some cases we need to hide an un-necessary export option from a default web site of a reporting server.
We will hide all these export options that you see in the following image.

report

Now I will describe how to hide these options from the reporting server default website.
Go to the specific path in your machine such as:

C:\Program Files\Microsoft SQL Server\MSRS11.SQLEXPRESS\Reporting Services\ReportServer

Then in this stuff we need to open the rsreportserver.config file.

rsreportserver

Then we need to make some changes in this file. In this file we need to set the property Visible="false" for a specific XML tag.

property

Then save this file and re-start the reporting server.

Then we can see here all the options are not visible here.

reporting server

(2) Add banner in report server website.

Now we will how to add a banner to the reporting server default web site.
For this we need to customize the report manager style sheet.

Go to the specific path in your machine such as:

C:\Program Files\Microsoft SQL Server\MSRS11.SQLEXPRESS\Reporting Services\ReportManager\Styles

ReportManage

Here we need to make changes in ReportingService.css file. Initially we need to place an image in the image folder. The Folder path is:

C:\Program Files\Microsoft SQL Server\MSRS11.SQLEXPRESS\Reporting Services\ReportManager\images

Here we need to place our own banner image. Then go to the ReportingService.css file and customize that [table.msrs-header] specific class in the CSS file.

The following is the customize code for that specific class:

table.msrs-header { padding-left:10px; background-image: url("../images/test.jpg"); height: 92px;background-repeat: no-repeat;}

Then we can see the output here.

output

(3) Hide Data source folder and Dataset folder

We can also hide an un-necessary folder from the reporting server default website. Folder like DataSource and Dataset. These folders are not used by the client so we can hide these folders also.

Data source

Go to the Dataset folder and click on the down arrow then select Manage.

Manage

Then check hide in the tile view then select Apply.



Then we can see that the Dataset and Datasource folders are not visible here.

Datasource folder

But one thing we need to remember at this point is that this folder is not visible in tile view only but when you change the website content view to detailview then we can see both folders that are shown in the following image.



That's one issue here. In the next point I explain how to hide the detail view button from the website.

(4) Hide detail view button from reporting server default website

For this we need to set the visibility of the detail view button. We need to write this #ui_btnSwitchView{visibility: hidden;} code at the end of ReportingServices.css file then save this file.

After doing that we can see the detail view button is not visible in the website.

reporting server page