9

I have created a few reports which like users to be able to access via url mainly. I want to hide the menu options in these URLs'. Not sure how to do this this. This link:

remove-top-links-from-report-server

would require one to modify the actual css file, while this link: hiding-tool-bar-from-the-ssrs-report-while-using-them-in-dashboard-crm-2011

alludes to appending the url with'&rc:Toolbar=false' which i cannot get to work. So any suggestions or am i left with modifying a css file?

Arantuath
  • 243
  • 2
  • 5
  • 14

7 Answers7

9

Try &rv:Toolbar=false instead of &rc:Toolbar=false

This worked for me.

http://msdn.microsoft.com/en-us/library/ms152835.aspx

Eric
  • 958
  • 1
  • 11
  • 28
  • Sorry For the delay. I will check this out and get back to you, although if memory serves i did try this but it did not work. – Arantuath Jul 18 '13 at 16:01
  • Your answer was correct but my url was wrong in general.I used this post:http://stackoverflow.com/questions/1078863/passing-parameter-via-url-to-sql-server-reporting-service to correct my url. – Arantuath Jul 19 '13 at 15:28
  • Sorry... I should have posted the full url. – Eric Jul 23 '13 at 13:44
  • Absolute life saver, we were utilizing the &rc:Render=true and wondering why the top bar had suddenly gone missing. – cjones26 Nov 03 '17 at 19:35
1

Additionally to the answer from

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6c4a0722-b7cc-4a77-9c28-95cb478b743f/remove-top-links-from-report-server

Please open the Report Manager folder. In Reporting Services 2008 (R2), the folder is :\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ ReportManager.

Open the folder “Styles”.

Open the file “ReportingServices.css” using Text Editor such as Notepad.

Change the “table.msrs-topBreadcrumb” to be the following:

table.msrs-topBreadcrumb { background-color: #EBF3FF; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 84%; font-weight:normal; color:#666666;display:none}

And this I added myself :

.toolbarbuttonscell {display: none;}

Save the file.

AceAlfred
  • 1,111
  • 3
  • 21
  • 35
1

One option that might work is to go view the report, go to IE tools->Compatibility view settings, and add the site that the report is viewed at.

DiggityCS
  • 111
  • 7
1

Try amending the URL as below (adds 'ReportServer' and calls 'ReportViewer.aspx')

Examples:

https://devreports01/ReportServer_INST01/Pages/ReportViewer.aspx?ReportName

https://devreports01/Reports_INST01/Pages/Report.aspx?ItemPath=ReportName

I noticed that the window loaded after deployment did not include the toolbar and this was because of the URL. Seems to be the easiest way to lose the toolbar.

Siyual
  • 16,415
  • 8
  • 44
  • 58
will webster
  • 574
  • 5
  • 11
0

You can do this configuring the object with c#, setting the "ShowToolBar" option to false. Find the file "you_report.apsx.cs" and modify the "LoadReport" action, like this:

private void LoadReport() {
    this.rptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
    rptViewer.LocalReport.ReportPath = Server.MapPath("~/path_to_you_report.rdlc");
    rptViewer.LocalReport.DataSources.Add(datasource);

    rptViewer.ShowToolBar = false; //This hide the toolbar

    rptViewer.ServerReport.Refresh();}

Update:rptViewer.ShowToolBar = false does not work with SSRS 2016 try instead rptViewer.ShowParameterPrompts = false; it Worked for me

Rain
  • 85
  • 11
César León
  • 2,941
  • 1
  • 21
  • 18
0

For mobile reports add this as a query string parameter

rs:embed=true
MobileMon
  • 8,341
  • 5
  • 56
  • 75