I am creating a report in SSRS 2008 R2.
In the report, email and ClassName are the parameters and when a teacher enters his email, then based on this it will display all the Classes associated with that teacher.

Now In the report based on the ClassSelected, it should all the information for the class
i.e. Classdate , # registered and # attended etc.

I have another report called feedback report which contains feed back from the students and I want to use it as a subreport .
I want to display the feedback from only those students who attended the event and the field “Status “confirms that.

So for the subreport (feedback) report, I have created dataset from the query
Select feedback from tbl where Classname in (@classname) and email =@email and Status = ‘A’
For the main report (Class report), I am using a stored procedure.

The problem is when I select all the classes associated with a teacher, it displays the details of the class in the main report correctly but only displays only 1 feedback for that user and not all form the students who have attended the class.
I am creating a report in SSRS 2008.
In the report, email and ClassName are the parameters and when a teacher enters his email, then based on this it will display all the Classes associated with that teacher.

Now In the report based on the ClassSelected, it should all the information for the class
i.e. Classdate , # registered and # attended etc.

I have another report called feedback report which contains feed back from the students and I want to use it as a subreport .
I want to display the feedback from only those students who attended the event and the field “Status “confirms that.

So for the subreport (feedback) report, I have created dataset from the query
Select feedback from tbl where Classname in (@classname) and email =@email and Status = ‘A’
For the main report (Class report), I am using a stored procedure.
Classname and Email are the paramenters in the subreports as well which I am passing through the main report.

The problem is in the subreport that when I select all the classes associated with a user, it displays the details of the class in the main report correctly but only displays 1 feedback for that teacher.

Any suggestion is appreciated.

Thanks,
Blyssz

is the email (teacher) also tagged aains every piece of feedback?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244: How to get the best answers before you ask a question

sorry.
aains = against

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244: How to get the best answers before you ask a question

Yes, the feedback report is a separate report which gets email and ClassName as parameter from the main report. I did change the dataset source as Changed it from Query to stored procedure and the stored procedure returns correct rows when I pass email and name of all the classes but in the report, the parameter for Classname is passing only first value i.e. only 1 classname which comes first in the dropdown menu for the Class.
(In the profiler, it is displaying only one Classname value instead of 3)

how are you populating the parameters to pass to the subreport?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244: How to get the best answers before you ask a question