Customize SQL Server Reporting Services Reports Manager Portal

By:   |   Comments (4)   |   Related: > Reporting Services Configuration


Reports Manager is the default report management portal for SQL Server Reporting Services (SSRS) reports. One of the basic standard requirements for any application that is deployed in an enterprise, is to brand the application. A corporate branding standard is generally a set of specifications for the company logo, color scheme, fonts and other appearance related items. Reports Manager is a web application which would also be expected to be branded as per the corporate branding specifications of an enterprise. In this tip we look at how to customize the Reports Manager portal.


Consider an enterprise has an installation of SQL Server Reporting Services (SSRS) and they intend to roll out the Reports Manager portal to the entire user base of the organization.  The IT team has been asked to brand the application as per the company's corporate theme including the corporate logo. Follow the below steps to brand the Reports Manager portal.

Step 1: Open the SQL Server Reporting Services Reports Manager portal in a web browser as shown below. It has the default theme applied.

SQL Server Reporting Services Default Theme

Step 2: In order to brand the Reports Manager portal, one needs to create a brand package which will contain the entire set of specifications like logo, color specification and other settings.

Typically a brand package consists of the following files:

  • metadata.xml - This file allows you to set the name of the brand package, and has a reference entry for both your colors.json and logo.png files.

  • colors.json - When the brand package is uploaded, the server extracts the appropriate name/value pairs from the colors.json file and merges them with the master LESS stylesheet (brand.less). This LESS file is then processed and the resulting CSS file is served to the client. All colors in the stylesheet follow the six-character hexadecimal representation of a color. The file settings would look as shown below. You can watch a small video to learn more about the details of configuring the colors.json file here.

  • logo.png - If you include a logo with your brand package, it will appear in the web portal in place of the name you set for the web portal in the Site Settings menu. The file you include for the logo must use the PNG file format. The file dimensions will be scaled once uploaded to the server. It should scale to around 290px by 60px.  For this example I am using the Microsoft logo.

Colors.json for SQL Server Reporting Services

Step 3: Once you have all the files, create a zip file containing all the files. On the Reports Manager, click on Settings icon and select "Site Settings". Select the branding tab, and upload the brand package created in Step 2.

Upload Brand Package in SQL Server Reporting Services

Step 4: Once the brand package has been applied, the colors and logo specified in the brand package will be applied to the portal as shown below.

Brand theme in SQL Server Reporting Services

In this way one can brand the Reports Manager portal in SSRS as per the brand specifications of an enterprise.

Next Steps
  • Download the sample brand package from here and modify the color scheme as well as the logo to create a customized brand theme for the SSRS Reports Manager portal.
  • Check out all of the SQL Server Reporting Services resources.

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Thursday, June 25, 2020 - 4:05:52 AM - Wesley Back To Top (86038)


We currently using SQL Server and SSRS 2014, we would like to customize our landing page.

Would this be possible in 2014 or would we need to upgrade to 2016 in order for it to work?

Kind regards

Saturday, May 27, 2017 - 10:16:09 AM - Hamid Back To Top (56108)


Regards to branding ssrs portal, i want to know is it possible to translate strings in web portal?



Monday, October 17, 2016 - 1:20:24 PM - Anne Back To Top (43580)

 Try to use this function. But I cannot see branding item on the menu. It is missing.

I am using SSRS 2016 cumulative 2 which is the newest. and Standard edition.

Is it only available in Enterprise edition?





Monday, October 17, 2016 - 11:42:33 AM - Jacque Back To Top (43579)

 Hi Siddharth,

Does this tip apply to just SSRS 2016?  Or can it be used in other versions?  I'm currently using 2014 and would love to be able to customize our Reports Manager Portal.



get free sql tips
agree to terms