Creating SSRS report in SharePoint 2010 with multiple SPLists

Question

I have SP Lists

Students: StudentID, Name, Address,Email Course: CourseID, Name, Duration, Fees StudentCourse: StudentID, CourseID

How can I query these lists and create a SSRS report displaying StudentID, SudentName, CourseID, CourseName, Duration in a table. Need to combine these lists to create a dataset.

Answer 1

Simply fetch data from different lists in datatables and than join them.

Follow the link it will solve your problem

http://www.a2zmenu.com/Tutorials/SharePoint/List-Join-operation-in-SharePoint-2007---2010.aspx