2

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!

1 Answer 1

1

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:

https://stackoverflow.com/questions/9891861/reporting-services-and-custom-datasource

3
  • 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, 2013 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 msdn.microsoft.com/en-gb/library/ff521587(v=office.14).aspx or msdn.microsoft.com/en-gb/library/fp142385.aspx in SharePoint 2013)
    – James Love
    Mar 29, 2013 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, 2013 at 19:31

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.