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!