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

  • May 2, 2014 at 3:18 am

    #1710285

    Create a parent group and set the expression to

    IIf(RowNumber(Nothing)<=10,1,2)

    and set page break on the group

    Far away is close at hand in the images of elsewhere.
    Anon.