Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
In SSRS 2008, how to get the address bar URL. Is there any built-in function?

问题 In SSRS 2008, how to get the address bar URL. Is there any built-in function?

  • Saturday, May 05, 2012 6:21 AM
     
     
    Sign In to Vote
    0

    I am using SSRS 2008 with sharepoint 2010 integrated mod.  I want to pass the current URL like:http://portal.companyname/sitename/subsitename to report. Since I have 100 subsites, I need pass "subsite" as parameter to report. 

    Thanks!

     

All Replies

  • Monday, May 07, 2012 1:22 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi SharepointUserHouston,

    To view a report on a SharePoint integrated mode report server, we can use the URL like this:
    http://<servername>/sites/ssrs/My Reports/test.rdl&rs:Command=Render

    In addition, we can also add URL parameters to customize the report rendering. For example, the following URL passes two parameter values to the report and set the report rendering extension to Excel:
    http://<servername>/sites/ssrs/My Reports/test.rdl&Quarter=2&Year=2004&rs:Format=Excel

    For more information, please see:

    If you have any questions, please feel free to let me know.

    Regards,
    Mike Yin

     
  • Monday, May 07, 2012 2:24 PM
     
     
    Sign In to Vote
    0

    Maybe I need explain more about my question:

    I've built a report but I need to get a paramater from the sharepoint url that is hosting the report.  So, is there a way to parse the host url so that I can get this value.

    For example:

    http://portal.Wallmartgroup.com/wallmart/Houston610   is the site url for the sharepoint site that will run the report. The "Houston610"in the URL and is a text I need to grab to use as a parameter.

    I need to grab this from the sharepoint url because this report will be hosted on thousands of sites.  Each site will have a different text name

    (ie  http://portal.Wallmartgroup.com/wallmart/Houston610 or http://portal.Wallmartgroup.com/wallmart/sugarlandHw6) that represents a different store name.  So, I want to create a site template that I can deploy over and over again without having to go in and modify the actual report to contain a new name every time a new site is created.

    So when I open the site URL like:http://portal.Wallmartgroup.com/wallmart/Houston610, I will get yeterday's sale report  from the page. I am using SQL Server Reporting Services Report Viwer web part to display the report.  And I am using SQL server reporter builder 3.0 to create the report. reporting service is in interated mode with sharepoint 2010

    Hopefully I was able to explain this well enough. Is this even possible?