Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2012-06-28 : 15:38:31
|
| We are reporting against a SharePoint List that is replicated in more than 10 subsites, and would like to have the SharePoint Query element for the ListName be dynamic. Reason is, we want a single report to be used for all 10 subsites since each subsite the same list...just different data.We would like to be able to pass the list name in the query string as a parameter so the report can be dynamic, and we won't have to have 10 exact copies of the same report. We've already figured out the subsite dynamic part which resides in the datasource portion, and that's working...it's just down to the SharePoint Query XML and the <ListName> element where we need to insert the parameter.We have tried the following 4 ideas with our parameter @List, but we get a "List Not Found" error when trying to view the report for each scenario:1. <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ListName>List [@]</ListName> <ViewFields> ...2. <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ListName>List {@}/ListName> <ViewFields> ...3. <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ListName>@List</ListName> <ViewFields> ...4. <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ListName>=Parameters!List.Value</ListName> <ViewFields> ... |
|
|
|
|
|
Dynamic SharePoint <ListName> via Report Parameter