I want to create a report with SSRS that consumes data from SharePoint list. When I add a new shared data source in the Business Intelligence Studio, all the options other than the SharePoint List are displayed in the "Type" as shown below.

enter image description here

Please let me know is there any method to get SharePoint List as a connection type here. Please guide.

  • It would be great if you can let us know if you are using VS or Report builder. Can you please post a screenshot where it is grayed. – Taran Goel Jun 29 '15 at 8:41

Please create a Shared Datasource instead of "Datasource". I'll suggest you to read this step by step article, it helped me with my first report. J

  • This was what I was doing, but during the creation of Shared Data Source, I was unable to get the connection type as SharePoint List. Please see the edited question above. – Mancy Desaee Jun 30 '15 at 6:22
  • 2
    You can select XML and give the list webservice url. nikpatel.net/2010/04/30/… – Taran Goel Jun 30 '15 at 6:37
  • Is this the last alternative to access the SharePoint list data in SSRS? – Mancy Desaee Jun 30 '15 at 8:56
  • Both selecting XML or Sharepoint uses webservice to fetch data. The only difference that's there is the fact that you give URL in sharepoint as a source whereas you give webservice url in XML. If you can provide me the exact details of the report builder you are using and what additional software you installed, I can try to replicate the scenario. – Taran Goel Jun 30 '15 at 9:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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