repeat "reference" chart within each group on on each page

• BaldNomad

  SSChasing Mays

  Points: 658

  More actions

  July 25, 2014 at 1:00 pm

  #296742

  I have one data set in my report that includes frequency values for both "reference" and "comparative" event types. I would like to display a chart showing the "reference" values, with a chart directly below it showing ONE set of potentially MANY "comparative" values. I would like to use page breaks to allow the user to "flip" from the first comparative chart to the next, while always displaying the "reference" chart above.

  Anyone know how to accomplish this using lists/groupings?

  Here are more specifics:

  dataset includes columns for:

  instrument serial #

  event_type code

  position - there are 30 physical positions within the instrument in which events may occur, the charts show the distribution of events across positions.

  num_events - summary count of events from the raw transaction data

  There is one value for "event_type" that has been designated as the "reference". All other event types can be compared to the reference events.

  Both charts are stacked bars with num_events on Y axis, position on X axis, and each instrument with it's own "stack" in each bar.

  The top chart should always show the results when the event_type is "Reference".

  The comparative chart should show the results for each OTHER event_type, but I would like to show one at a time. When the user goes to page 2, they would see the SAME reference chart and the NEXT event_type in the comparative set.

  The attachment shows what I am trying to do visually. I was able to get it working in part by putting the second chart inside a list (single-celled tablix) and setting it to group on event_type, filtering OUT reference events and setting it to page break between groups. But this method only displays the reference chart on the first page. I don't think you can really add charts to page headers so that probably isn't the right approach. How can I get the reference chart to repeat on each page?

  I could also create separate data sets for each chart if that makes anything easier.

  BTW this is on SSRS 2008R2 but I'd upgrade the whole project to 2012 if that would help me solve this problem...

  any help appreciated, thanks!