SSRS: Include Parameter in SharePoint List Connection String


In SQL Server Report Builder I can create a Microsoft SharePoint List connection to my sub sites by making the connection string:


Is it possible to have the connection string an expression that gets the SubSite name from a parameter, so something like:


I can't seem to get the correct syntax to work.
Who is Participating?
lee_murphyAuthor Commented:
Cheers colly.  It turns out that, typically, I kept at it after posting the question and found the answer.  the parameter I was using was correct (="http://SharePointServer/Sites/" & Parameters!SubSite.Value) however it doesn't work at design time, so I had to create two connections, one with a link to a subsite, used to design the form, and one using the parameter syntax and swapping the source of the DataSet before testing it in runtime, seemed to work.
Provided that the SharePoint list connection string does allow Expression Based Connection Strings, Expression based connection strings have this sort of syntax:

="http://SharePointServer/Sites/" & Parameters!SubSite.Value

or maybe:
="data source=http://SharePointServer/Sites/" & Parameters!SubSite.Value

I haven't got a system to test it on so post any error messages it gives.
lee_murphyAuthor Commented:
I figured out the answer myself.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.