I'm, looking at how to manage some lists in SharePoint 2010 and have to use SQL 2008 Reporting Services to make reports on these lists. I'm new to Reporting services and is wondering if you can make reports on multiple lists in SharePoint 2010 or just one list?
closed as off topic by Alex Angas May 18 '11 at 0:30
Questions on SharePoint Stack Exchange are expected to relate to SharePoint within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.
You can add one data source per list for your report (ie: multiple data sources within your report), this Q on StackOverflow asked something similar I think:
Reporting Services allows you to use a web service as your data source, so if you only needed to retrieve items from one list you could use the GetListItems method in the lists.asmx service. i.e.
Data source > connection string: http://server/_vti_bin/lists.asmx
Report > Dataset > Query string:
However, if you need to join 2 lists this will not be sufficient. If you are more proficient in .NET than SSRS, it might be easier for you to write your own web service that calls lists.asmx and returns the joined list the way you want it. Then use your custom web service as the data source.