How to use URL Access in Reporting Services SharePoint integration mode

URL Access still works if you’ve put your SSRS instance into MOSS integration mode, it just takes a bit of extra work. Here’s an example using the following assumptions:

· SSRS itself is installed on a machine called ssrsBox

· MOSS is installed on mossBox

· The report “aReport” is stored in a report library named “theReportLibrary”

https://ssrsBox/reportserver?https://mossBox/theReportLibrary/aReport.RDL

…if SSRS was installed on the same machine as MOSS (maybe on port 8080?) your URL will look like this:

https://mossBox:8080/reportserver?https://mossBox/theReportLibrary/aReport.RDL

Comments

• Anonymous
  August 09, 2007
  Is it possible to pass parameters to the reports via the URL?I's really like that.
• Anonymous
  August 21, 2007
  To pass parameters, simply add "&MyParam=myValue" to the url. For instance:http://mossBox:8080/reportserver?http://mossBox/theReportLibrary/aReport.RDL&rs:Command=Render&rc:Toolbar=false&rc:Parameters=false&MyParam=myValue-Franck
• Anonymous
  October 18, 2007
  The comment has been removed
• Anonymous
  October 19, 2007
  Not that I know of.
• Anonymous
  October 22, 2007
  Is there a way to pass parameters to a Sharepoint page that has the SSRS web part linked to a specific report?
• Anonymous
  March 04, 2008
  This works - I was ignoring the "rs:" and "rc:" items in the querystring. Since the parameters were hidden in my jump report it was necessary to specify rc:Paramters = false else it would give a Parameter missing error on opening the jump reportThanks!
• Anonymous
  March 19, 2008
  Great stuff!  How did you know what I was looking for?I wish this stuff was covered this simply in the docs.Here's a problem I had: I could not pass a parameter in a URL if it was defined as a Query.  As soon as I made it a Value it works.  I did not find that in any docs.  Does anyone know why this is?
• Anonymous
  March 27, 2008
  This is what I have for passing a parameter to another report, but This gives me an error of Error during processing of ‘DimKeyMeasureMeasureName’ report parameter. (rsReportParameterProcessingError) ??Does anyone have an idea of what I am doing wrong.="http://reportservername/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=/reports/edpd/im/imcharts_supervisor.rdl&rc:Paramters=false&DimKeyMeasureMeasureName=Parameters!DimKeyMeasureMeasureName.Value"
• Anonymous
  August 04, 2008
  Any ideas on how to hide the breadcrumbs and the toolbar of the report in Sharepoint Integrated Mode? My URL is:http://vpc-pps/Reports/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=/reports/reportslibrary/net%20temp/system/admin/report_46_27252008020733.rdland I would like to at least hide the top breadcrumbs that show: Home > Reports > Reports Library > etc, etc.Thanks!
• Anonymous
  April 30, 2010
  I have tried this over and over it would not put it does not work ssrs sql srv 2005 I setup a parameter prmUID , as a text Available values non qry --nothing -- Defualt value null http://srvras01/Reports/Pages/Report.aspx?ItemPath=/PSR/ACCEPTANCE/psrMaterial&rs:Command=Render&prmUID=ahattia