How Do I Hide the Toolbar When Running My Reports?

In my last blog post, I talked about how some of my clients run into the problem of how to maximize the size of their dashboard reports when displayed on wall monitors. In order to solve this problem, I showed you how to set your browser to full screen mode. This works, but it still leaves the SQL Server Reporting Services (SSRS) toolbar visible (see the arrow below). This blog post will show you how to remove the SSRS toolbar when running reports.

How Do I Hide the Toolbar When Running My Reports-Green Arrow

As a refresher, in order to have a dashboard use the full screen, there are a few things that you need to do:

· Set your browser to full screen mode.

· Access the report via the report server URL instead of the reports URL.

· Add a command to the URL to hide the toolbar.

The first item was covered in the last blog post, so let’s move onto the next item, how to access the report server URL.

It is not well-known, but there are two URLs that you can use to access reports from a web browser. The main one (the most common) is the reports URL. In my case, this is what it looks like: http://cm-cas-rs1/Reports.

How Do I Hide the Toolbar When Running My Reports-Main URL

The second URL (not well-known) is the report server URL. In my case, this is what it looks like: http://cm-cas-rs1/Reportserver.

How Do I Hide the Toolbar When Running My Reports-Second URL

It becomes quickly obvious why you would use the first URL instead of the second one. It looks nicer!

At this point, you might be asking, “Why access the second URL at all?” Well, the second URL (report server) will allow you to add commands to the URL in order for actions to be performed when running a report. By adding a command, we can hide the SSRS toolbar (see arrow).

How Do I Hide the Toolbar When Running My Reports-Purple Arrow

When I run my report from the report server URL, normally I get the following:

http://cm-cas-rs1/ReportServer/Pages/ReportViewer.aspx?%2fConfigMgr_RS2%2fEnhanced+Web+Reporting+v5%2fSystem+Center+Endpoint+Protection+(SCEP)%2fSystem+Center+Endpoint+Protection+(SCEP)+Dashboard&rs:Command=Render

In order to hide the toolbar, append the following to the URL:

&rc:Toolbar=false

As you can read, this parameter clearly turns off the toolbar. Now my URL looks like this:

http://cm-cas-rs1/ReportServer?%2fConfigMgr_RS2%2fEnhanced+Web+Reporting+v5%2fSystem+Center+Endpoint+Protection+(SCEP)%2fSystem+Center+Endpoint+Protection+(SCEP)+Dashboard&rs:Command=Render&rc:Toolbar=false

When I run my report after adding this command, I see the following. Notice that the toolbar is no longer there!

How Do I Hide the Toolbar When Running My Reports-No Toolbar 

This simple trick will give you additional extra space, so that your report can use the full screen. Doesn’t it look better? If you have any questions, please let me know @GarthMJ.

Showing 7 comments
  • Maxwel
    Reply

    AMAZING!
    tHANK YOU

    • Garth Jones (Admin)
      Reply

      You welcome, I’m glad that I could help.

  • Leo
    Reply

    hey, is there an option to have the toolbar fully open all the time? i have some filters on my toolbar that i would like to be accessible while using it.

    • Garth Jones (Admin)
      Reply

      Use &rc:Toolbar=true should do the trick.

  • Vazhumuny Manickasamy
    Reply

    Hi Garth,
    I have gone through your information really helpful. but in my case I have report with three parameters.
    if I don’t have parameter report &rc:Toolbar=false working fine. I would like to user need to select parameter values first then I would like to hide the toolbar. parameter report I have tried passing parameter values in the url then hide the toolbar also working fine. all I am trying to achieve here is I don’t to show toolbar information to user to avoid save and print the report

    Thanks,
    Vaz

    • Garth Jones (Admin)
      Reply

      Hi Vaz. My quick test this morning say that you can’t do that. You might be able to edit the SSRS config file to have it always not display the toolbar for any reports but that is an educated guess on my part. if you do figure it out, please let me know.

      • Vaz
        Reply

        Sure. Thanks for your reply.

Leave a Comment