SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm new to SP and SSRS, so I want to check if my thoughts are correct. Report Builder and BIDS suck on data retrieval so I have to go deeper using code.

Is it possible to write some code in C# using LINQ statements for retrieving multiple SharePoint content (lists) and create a new list, which I could use as a dataset for Report Builder to generate reports on?

In general, what are the steps from code (.NET + LINQ) to report deployment (using the visualizations and the tools of SSRS?

Thanks in advance!

share|improve this question
up vote 1 down vote accepted

Think you're going to want to create a Custom DataSource.

This post on StackOverflow asks pretty much the same question as yours (though generalised to more than just SharePoint as a source), with some good links in the answers:

share|improve this answer
I'll give it a good look, thx James! But I'm also curious about how people are using reporting services with SharePoint. Whats the process. The expressions of BIDS/RB are so limiting.. – LePhleg Mar 29 '13 at 15:14
Depending on what version of SharePoint you're running, you could also try using the XML Data Source and hooking it up to the OData endpoints that SharePoint providers (check out or in SharePoint 2013) – James Love Mar 29 '13 at 19:31
But other than that, and the standard SharePoint List data source, these provide for the majority of scenarios of getting data out of lists. – James Love Mar 29 '13 at 19:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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