Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

2 Answers 2

To do this without building deployable code and only using the SSRS Report Builder, use the LookupSet and Join commands. Load both the Student and Course lists as datasets, setting any filter queries you might need and to join them in a tablix, you can use some expression along the lines of:

=Join(LookupSet(Fields!StudentID.Value, Fields!StudentID.Value, Fields!Name.Value, "Course"))

Create the Tablix based on the primary list, then in the join expression, use the second list to join on. The 1st parameter in the Expression is the Primary Key, the 2nd is the Foreign Key, the 3rd is the value to extract from the join and the 4th is the Foreign dataset name

The LookupSet information on Technet

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.