SSRS: Include Parameter in SharePoint List Connection String

Hi,

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

http://SharePointServer/Sites/SubSite

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

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

I can't seem to get the correct syntax to work.
lee_murphyAsked:
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.
0
 
colly92002Commented:
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.
0
 
lee_murphyAuthor Commented:
I figured out the answer myself.
0
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.