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

Comments (10)

  1. Minimia says:

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

    I’s really like that.

  2. Anonymous says:

    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.

  3. Anonymous says:

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

  4. Anonymous says:

    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!

  5. Anonymous says:

    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?

  6. Anonymous says:

    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"

  7. Anonymous says:

    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!

  8. Azmi Attia says:

    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