Search code examples
reporting-serviceschartsssrs-2008-r2ssrs-tablix

SSRS 2008r2 Show data in Table and Charts based on x number of rows at a time

I have a report which contains a table and a number of charts.

Is it possible to show x number of rows on each page and just the data in those rows in the charts?

Solution

  • Add a parent row group, grouping on =(RowNumber(Nothing) - 1) \ 10. Add a footer row to that group. Put your chart in that footer row. Set that group to pagebreak between.

    =(RowNumber(Nothing) - 1) \ 10 returns 0 for the first 10 items, 1 for the next 10, etc. Grouping on that with pagebreaks will give you pages of 10 records. Charts in the group footer cells will use just those 10 rows (by default).