I want to show many small bar charts in a grid. Each row in the grid is a student. Each column is a subtopic, showing a student's performance on questions within that subtopic. Each chart shows a bar for each year the student was tested for that subtopic.
That all works fine, nesting the charts within a list and/or repeater table. The problem appears when I include district average performance marks along with each bar in the charts for reference. The report can take several hours to run. I think the problem is that the district averages are fetched and recalculated for each chart. This occurs even if I mark "Use Local Cache", probably because the query has to retrieve different values for each subtopic as it goes across the columns. Never mind that the same half dozen subtopics are repeated for each row--I don't think the cache is smart enough to cache different versions of the same query. Or is it? Maybe I haven't found the right way to structure the queries yet.
Any ideas welcome, and thanks!
David
did you ever get a resolution to this problem? I'm facing the same issue.