Customizing Reports Manager (SSRS 2008 R2)

Question

Post reply

Customizing Reports Manager (SSRS 2008 R2)

Mark Eckeard

Hall of Fame

Points: 3462
More actions
October 6, 2012 at 4:20 pm

#265410

All,
I'd like to make some small cosmetic changes to my install of Reports Manager (SSRS 2008 R2). Maybe change the color of the tool bar and add a logo.
I was able to find this style sheet file on my PC:
C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\Styles\ReportingServices.css
However, making changes to this file does not show within Reports Manager.
When I do a view source on the page, here's a reference I see to a style sheet:
/Reports/styles/ReportingServices.css
The path doesn't match the path I listed first.
How can I get access to the css file being referenced in the home page of Reports Manager?
Thanks,
Mark
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

Hi Mark,

That looks like the right style sheet...

Here is one I just did to test it works:

And the bit of the css that I changed...

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Mark Eckeard Hall of Fame Points: 3462 More actions · Answer 2

mister magoo,

Odd, I tried clearing my cache numerous times yet didn't see any changes to that style sheet but I tried once more and it worked.

Thanks for the help!

Regards,

Mark

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

Ah good, glad to help:-D

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

H4K Hall of Fame Points: 3374 More actions · Answer 4

Thank you for this Information.:-D

BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI

tdodd Valued Member Points: 65 More actions · Answer 5

Sorry for the late reply (2 years), but I recently bumped into this, and came up with the following solution.

The solution for SSRS 2008/2008R2/2012 is to use CSS to alter the rendering of the page.

1) Edit the following file: ReportingServices.css, located at C:\Program Files\Microsoft SQL Server\MSRS.[Instance Name]\Reporting Services\ReportManager

2) Line to be added just before the "body" specification:

[font="Courier New"]

@import url(customization.css)[/font]

3) Save the file, and create a new file in the same directory called "customization.css".

4) Place the following in customization.css:

[font="Courier New"].msrs.logo

{

height: 53px;

width: 125px;

background: url("../images/your_new_logo.jpg") no-repeat;

text-indent: -9999px;

}

[/font]

5) Add your replacement logo in the C:\Program Files\Microsoft SQL Server\MSRS.[Instance Name]\Reporting Services\ReportManager\images directory. Be sure that it matches the name and size that you specified in customization.css.

6) Bring up the SSRS web page and enjoy! This solution works well because it will preserve all of the positive customizations that can be performed via the web UI, and is minimally invasive on the back end.