How to hide items in the HTML Toolbar control for SQL Server 2000 Reporting Services

This is kind of old news since the feature has been around since SP1, but I haven't really played around with it until now: You can control the look and feel of the HTML report toolbar by using a custom cascading stylesheet and URL Access.

If you take a look in the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\styles folder, you'll see a sample css named htmlviewer.css (and if you've installed SP2, you get some new ones: SP_Full.css and SP_Small.css). Anyway, you can use the css to change the color and position of items in the toolbar, and even go so far as to hide them.

So, let's say for example that I don't want the toolbar to show the "Find", "Zoom", "Export" and "Print" parts of the interface...but I do want to continue to display the "Refresh" button: I'd just make a copy of the htmlviewer.css to work from and make the following modificatons:

.ToolbarFind

{
display: none;
}

.ToolbarExport

{
display: none;
}

.ToolbarZoom

{
display: none;
}

.ToolbarRefresh

{
display: inline;
}
.ToolbarPrint

{
display: none;
}

I'll save this css as "test.css" in the \styles folder.

Then, to display my report, I'd use URL Access: https://myReportServer/reportserver?/MyReport&rs:Command=Render&rc:Stylesheet=test

The only problem I had was due to a (dumb) assumption I made. If you review the SP1 readme closely, you won't make the same mistake, but I thought that htmlviewer.css always provided style info to Report Manager unless we specified a different one with the Stylesheet parameter. So, I got confused when I modified htmlviewer.css, but the changes didn't get reflected when I browsed reports without specifying any stylesheet. To get this feature to work you *must* actually specify a css name.