Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Change the Report Manager logo

 

A common question I've been asked a lot lately is how to replace the icon in the Report Manager to my company's logo. 

 

It is actually fairly simple to do by following these steps: 

 

1.  On the server reporting services is installed on open the folder C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager\images

2.  Rename the file 48folderopen.jpg to anything else (Ex. 48folderopenOLD.jpg)

3.  Resize your logo to be 48 x 48 pixels jpg file
4.  Rename it 48folderopen.jpg
5.  Copy your logo to the folder C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager\images

 

Open the Report Manager again to see the change.

 

Read my blog at my regular blog site http://www.bidevelopernetwork.com/blogs/DevinKnight

 

Comments

Posted by atulkumar2 on 24 November 2009

This is good to know. Thanks for sharing.

Posted by cameron on 25 November 2009

this is a great customization.  Following on a similar vein, does anyone know how to modify the text on the main page, i.e. SQL Server Reporting Services --> <your company name/> Report Manager, or something similar?

Posted by Dave Schutz on 25 November 2009

Great advice.

Posted by knight_devin@hotmail.com on 25 November 2009

cmayfield

If you select site settings in the top right of the report manager you can change the name.

Posted by beargle on 25 November 2009

Great article Devin, quick and easy way to personalize the site for your organization.

@cmayfield320 - To change the site header text browse to Report Manager, click on Site Settings, and change the text in the Name field. Click Apply to save changes.

Posted by vinizio on 25 November 2009

Thanks for sharing.

Posted by uatif on 25 November 2009

Thanks Dear, i was looking for it. And is there any way that we can further customize the look and feel..? Please advice that as well.

Posted by knight_devin@hotmail.com on 25 November 2009

You sure can.  If you're familiar with style sheets like in website design you can modify them here.  C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager\Styles.  Usually a good idea to make a copy before making changes to the style sheets.

Posted by Gosi on 9 December 2009

Great article. I've been trying to customize my report manager for a while and this helps me a lot. But I haven't been able to find a way to make further customization on the area where the logo is. I want f.ex. to remove home/My subscription/help from the top right corner and stretch the company logo so that it coveres the whole top area. Which file do I need to alter to make those modifications?

Posted by knight_devin@hotmail.com on 11 December 2009

I haven't tried that before but I did find this blog that may help with exactly what you're asking about.  weblogs.asp.net/.../reporting-services-add-a-logo-to-the-report-manager.aspx

Posted by Timothy MacKay on 12 June 2010

Is there an updated way to do this for SSRS 2008 R2? I cannot find the referenced image file in SSRS 2008 R2.

Posted by knight_devin@hotmail.com on 12 June 2010

Same way but in R2 the folder is C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\images and the image is called Folder_32

Posted by Timothy MacKay on 16 July 2010

Devin, thanks for the update. I had already found that image file and replaced it. Problem now is that it appears to be the same image for the folder icons in the main report window. When I changed the image all of my icons in all of my windows/folders changed also. Although not terrible, it is not the same behaviour as in 2005. Any thoughts?

Thanks again,

Tim

Posted by tamdphan on 29 October 2010

For some reason, when I changed the logo on the server, Report Manager does not show the new logo on individual desktop.  It does show on the server's IE.  Any ideas?

Thanks

Leave a Comment

Please register or log in to leave a comment.