0

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

JayTyo
  • 1

1 Answers1

0

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

Hannover Fist
  • 10,393
  • 1
  • 18
  • 39
  • 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 '18 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: https://blogs.msdn.microsoft.com/lukaszp/2009/12/21/charts-in-a-tablix-cell-dont-work-for-me-but-ive-see-these-nice-demos-where-they-do/ – Hannover Fist Aug 27 '18 at 18:57
  • Thank you very much Hannover. Your directions along with the link in your last post solved the issue. – JayTyo Aug 27 '18 at 19:13
  • Unfortunately, SSRS error messages are usually cryptic at best. – Hannover Fist Aug 27 '18 at 19:15