SSRS grouping
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, On my report i have used the following to display 100 reports per page =Floor((RowNumber(Nothing) - 1) / 100). The records are grouped by department. However I'm getting the group header on everypage. For example if I have 200 records for Department2 and 50 records for Department2, on the first page Department1 is displayed followed by 100 records and on page 2 the Department1 is displayed again followed by 100 records. I want the Department1 to be displayed only once even if the next 100 records are on the next page Any advice?