Page Break on Ranked Column

[bloggerman]

Could you please help me out with the below scenario

Report has rows for States and Cities. There is a caluclation which is ranked on States. The number of cities under a State are fixed but different. The number rows allowed on a page are fixed. Rows are such that each state is followed by its cities. We need a scneario where 2nd page shud always start with a State and shouldn't have a scneario where half cities of a state are on one page and the other half on second.

Eg

Page 1

State 1  100
City 1       20
city 2        60
State 2   80
City 3     40
city4       50
city 5      10

------------------------

Page 2

State 3    60
City 6      20
city 7       40
State 4     30
City 8      10
city9       10
city 10       20

We cannot have city 5 on second page. And column is sorted on value corresponding to State