Hi All,

suppose i have the following data in detail section:

column A       Column B
A               NY
B               London
C               Paris
D               London
E               London
F               Berlin
G               London

also, suppose that I have a group on some other field in the report besides the fields that i m mentioning above (just trying to say that there is group header and footer in report as well)

In this scenario, how will i make a formula that counts the number of times 'London' appears and if it appears more than 3 times, it moves the records to the next page.

please help....