Post reply

SSRS: how to put 10 rows on first page and rest (1000+) rows on the second page

  • May 1, 2014 at 4:10 pm

    #288374

    Hi,

    Is there any way to control this scenario, I know trick to put 10 on each row ,but I need to split them unevenly, 10 on first page and the rest on second page.

    is it possible ?

    =Ceiling((RowNumber(Nothing)) / 10)

  • May 2, 2014 at 2:22 am

    #1710268

    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.

  • 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.

  • May 2, 2014 at 8:36 am

    #1710365

    Thansk, David.

    Yee, it was dummy question, closer look revealed that it's really easy if working with groups

    Best

    Mario

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply