Sharepoint 2010 Foundation, SSRS Native Mode, Dynamic Parameters

Posted on 2012-08-16
Last Modified: 2014-12-01
I have a sharepoint 2010 Foundation server, name: sharepoint
I have an SSRS server (in Native Mode), name: ssrs

On ssrs there is a report (TestReport) which takes a single parameter (string): myparam

On sharepoint, I want to create a site template (there will be ~200 sites based on this template)

In th template, I want to render TestReport inside a ReportViewer webpart (I have already installed the required webpart from the SSRS install on the sharepoint server).

The URL that this site will be located at is like http://sharepoint/DemoSites/01009/ , where "01009" is the bit that will change for the ~200 or so sites (so http://sharepoint/DemoSites/01010/ is another one)

I want the ReportViewer webpart to render the report called TestReport, using  "01009" or "01010" as the parameter for myparam.

This way, I can use a single report, and have it render the appropriate data for the site it is being displayed on.

My current idea is to somehow extract the last part of the URL (and get "01009") and then pass this into the ReportViewer webpart for it to use as the value for the parameter for the report it will be rendering.

Any ideas on how to do this?  I have Visual Studio 2008 as my developer platform, and sharepoint designer 2010 instaled.
Question by:everardsbrewery
    1 Comment
    LVL 44

    Accepted Solution

    if coding is not the problem I would create a new filter web part. This will get the relevant part of the url and pass it as filter value to the report viewer web part.



    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now