I have an script that automatically creates a SharePoint list for each new SiteCollection in my WebApplication, so I have many different lists each contains the same columns. The lists name matches to the site collection name: SCMySite, SCDoc, SCTest,...

I want to build a dynamic report in SQL Report Builder 3 that meets the below requirements:

  • The columns will be constant
  • The list will be chosen dynamically (all the list contains the same fields).

Can I get the list name from a parameter?

I digged the google and did not find anything. Thanks for helping.

1 Answer 1


Ok I cannot see which version of SharePoint you are using. But you can use rest api for fetching data or SOAP method.

enter image description here

You can refer to the below Link where you will get all information http://blog.davidjwise.com/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux/

  • Please mark it as answer, if it helps you
    – Milind
    Jan 2, 2016 at 12:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.