CODEWITHSUNDEEP
reporting-services
Karthikeyan Dharmarajan
Karthikeyan Dharmarajan

Reputation: 11

SSRS - Limit records by group

I have a report which displays the records grouped by column "branch". Now i would like to limit my records to displays only 7 records per page. Break to display if the group is different. How do i do this?

Here is how i want my record to display.

Page 1:

Branch1

ID

1
2
3
4
5
6
7

Page 2:

Branch1

ID

8
9
10

Page 3:

Branch2

ID

11
12
13
14
15
16
17

Upvotes: 1

Views: 192

Answers (1)

Mike
Mike

Reputation: 550

You could create a group based off an expression that divides the row number by 7 and adds 1, then set the page break property on the group. The expression for the group would be like:

=(Fields!RowNumber.Value  / 7) + 1

Upvotes: 1

Related Questions