June 13, 2012 at 4:24 pm
I am new to SSRS.
I have a query resulting data for TeacherFirstName, TeacherLastName, TeacherID, Class,Subject, helperFirstName, helperLastName, helperEmail and StudentFirstname, studentlastname, Email, SubjectDate, subjectTime Etc.
I need to create a report in SSRS in which when a teacher enters the TeacherId , it will display his firstname and lastname and a dropdown menu which should disply all the claasses for this particular teacher.
Then once we select a class, it should display other information for the students who have taken the class like stfirstname, stlastname, email, subjectdate, subjecttime etc.
How should I proceed?
I am using ssrs2008.
Any suggestion would be appreciated.
Thanks,
Blyzzard
June 13, 2012 at 7:30 pm
amar_kaur16 (6/13/2012)
I am new to SSRS.I have a query resulting data for TeacherFirstName, TeacherLastName, TeacherID, Class,Subject, helperFirstName, helperLastName, helperEmail and StudentFirstname, studentlastname, Email, SubjectDate, subjectTime Etc.
I need to create a report in SSRS in which when a teacher enters the TeacherId , it will display his firstname and lastname and a dropdown menu which should disply all the claasses for this particular teacher.
Then once we select a class, it should display other information for the students who have taken the class like stfirstname, stlastname, email, subjectdate, subjecttime etc.
How should I proceed?
I am using ssrs2008.
Any suggestion would be appreciated.
Thanks,
Blyzzard
Google this: ssrs 2008 cascading parameters
You'll see lots of stuff, such as
http://msdn.microsoft.com/en-us/library/aa337498(v=sql.105).aspx
Essentially, each of your parameters will pass a value/values to the next parameter in line. When you select a teacher, the TeacherID value for the teacher parameter should be passed to the next parameter data set, so the Class list parameter will be filtered when rendered. And so on...
For example, your Class query should look something like
select class, [Subject]
from ClassesTable
where TeacherID = @TeacherID
Note also - the physical order of your parameters in the rdl is very important. You can't put the Class param above the Teacher param.
Best of luck with your learning!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply