AARA grouping charts

0
votes

I am converting a chart report from Crystal to SSRS. In Crystal the chart is in a group header, so I defined it once and for each new group. When the report is run the chart is printed once for each group. How do I do the same in SSRS. SSRS will not allow me to drag a field to the row groups or column groups area. Or do I have to copy the chart for each group in the data?

Thanks in advance

Jay Tyo

1
reporting-servicescharts

1 Answers

0
votes

To repeat a chart for different groups, use a LIST to do the overall grouping and put your chart or table inside it.

Here I have a table of data that I wanted to break up by location.

enter image description here

I created a List to group by location and put the table inside. Notice the grouping bracket on the left side of the tables. The LIST groups everything.

enter image description here

You would set the list dataset to the same as your data and group on the field(s) for your grouping.

MSDN - Lists

SSRS Group by in the List Report

YouTube: SSRS -- Using a List Item to Display Details