AARA grouping charts

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 Answer
1

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

That was a great idea. That got me to at least be able to create the list structure and add the grouping, but when I put the chart in details area I get a message that says "The chart has a detail member with inner members. Detail members can only contain static inner members."
– JayTyo
Aug 27 at 18:27

It sounds like you put the chart in a detail row rather than a grouped row in the list. Check this out: blogs.msdn.microsoft.com/lukaszp/2009/12/21/…
– Hannover Fist
Aug 27 at 18:57

Thank you very much Hannover. Your directions along with the link in your last post solved the issue.
– JayTyo
Aug 27 at 19:13

Unfortunately, SSRS error messages are usually cryptic at best.
– Hannover Fist
Aug 27 at 19:15

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

搜尋此網誌

Dfyjkt