I'll start by showing you the query behind the report:
SELECT q.QuestionNumber, q.Abstract, a.AnswerNumber, a.AnswerText, resp.FinalScore, grp.GroupName
FROM A_AssessmentInfo AS qs INNER JOIN
A_Question AS q ON q.AssessmentID = qs.ID INNER JOIN
A_Answer AS a ON a.QuestionID = q.ID LEFT OUTER JOIN
A_Response AS resp ON a.ID = resp.AnswerID LEFT OUTER JOIN
A_ProjectUsers AS pu ON pu.PersonID = resp.PersonID AND pu.UserResponseStatusID = 2 AND pu.AssessmentID = @QuestionSetID LEFT OUTER JOIN
[$Groups] AS grp ON grp.ID = resp.GroupID AND resp.GroupID IS NOT NULL
WHERE (q.AssessmentID = @QuestionSetID)
ORDER BY q.QuestionNumber, a.AnswerNumber
The report displays 1 question per page, with a stacked bar chart for each possible answer.
All answers are shown; even those that were not selected.
The issue is that I see "Series1" (or 2 or 3) in the legend.
I understand why. The above query gets ALL answers for ALL questions, and therefore gets ALL groups.
But some questions have answers that were not selected by a particular group; hence I get "SeriesN" in my legend.
Is there any way to avoid this?
If this were a single chart I suspect there would be no problem.
But having multiple charts, each on their own page, all based on the same query, is causing me grief.
Any suggestions would be greatly appreciated.
I've also attached a screenshot showing the issue.
Thanks in advance