Add Paging to a SSRS Tablix in Report Builder

0
votes

I currently have a report that consists of a single table/tablix that contains company name, year 1 revenue, and year 2 revenue. The table is sorted by year 1 revenue descending. The report often returns several hundred company names however. Is there a way to only display 10 records at a time and enable a paging option to then move on to the next group? I am using Report Builder 3.0.

1
reporting-servicesssrs-2012ssrs-tablixreportbuilder3.0
Possible duplicate of stackoverflow.com/questions/6200628/… and stackoverflow.com/questions/19003153/… – StevenWhite

1 Answers

-2
votes

  1. Create a row group on your "details" row and hide it. Set the group on to:

    Ceiling(RowNumber(Nothing))

It basically assigns whole numbers 1,2,3..to every consecutive chunk of 10 records.

  1. Next, in the page break options configure the page to break at the end of every instance of group.

Ta-da! Pagination done.