Home Forums SQL Server 2012 SQL 2012 - General SSRS: how to put 10 rows on first page and rest (1000+) rows on the second page RE: SSRS: how to put 10 rows on first page and rest (1000+) rows on the second page

  • I've struggled to do this kind of thing in the past, so ended up creating two datasets (one for the first 1o rows, and one for the remainder) and having two tablix components on the report with a page break inbetween. Luckily the SQL queries used for the two data sets let me split the rows quite easily.