Saturday, May 05, 2012 6:21 AM
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.
Monday, May 07, 2012 1:22 PMModerator
To view a report on a SharePoint integrated mode report server, we can use the URL like this:
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:
For more information, please see:
If you have any questions, please feel free to let me know.
Monday, May 07, 2012 2:24 PM
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.
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?