Welcome to MSDN Blogs Sign in | Join | Help

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”

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

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

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

Published Saturday, February 24, 2007 5:20 PM by russch

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: How to use URL Access in Reporting Services SharePoint integration mode

Friday, August 10, 2007 7:43 AM by Minimia

Is it possible to pass parameters to the reports via the URL?

I's really like that.

# re: How to use URL Access in Reporting Services SharePoint integration mode

Tuesday, August 21, 2007 11:48 AM by Franck

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

# re: How to use URL Access in Reporting Services SharePoint integration mode

Thursday, October 18, 2007 10:08 AM by - BP

Is there any syntax in the URI that would allow the SSRS report passed paramaters without referencing the SSRS box via a domain name?

I have the SSRS and MOSS on different physical machines with only the MOSS box exposed to the users.

# re: How to use URL Access in Reporting Services SharePoint integration mode

Friday, October 19, 2007 11:33 AM by russch

Not that I know of.

# re: How to use URL Access in Reporting Services SharePoint integration mode

Monday, October 22, 2007 6:30 PM by Cam

Is there a way to pass parameters to a Sharepoint page that has the SSRS web part linked to a specific report?

# re: How to use URL Access in Reporting Services SharePoint integration mode

Wednesday, March 05, 2008 5:29 AM by Gayatri

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 report

Thanks!

# re: How to use URL Access in Reporting Services SharePoint integration mode

Wednesday, March 19, 2008 8:24 PM by MikeG

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?

# re: How to use URL Access in Reporting Services SharePoint integration mode

Thursday, March 27, 2008 12:00 PM by Corey

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"

# re: How to use URL Access in Reporting Services SharePoint integration mode

Monday, August 04, 2008 10:01 AM by Paul D

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.rdl

and I would like to at least hide the top breadcrumbs that show: Home > Reports > Reports Library > etc, etc.

Thanks!

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker