I am writing a report that when it reaches say 30 records then moves to another page. I want the report as follows

 

On Page 1

 

Street

Town

 

Street

Street

 

On Page 2 etc

Street

Town

 

Street

Street

 

I have said in crystal reports when records equal 30 then new page but I sometimes get

 

 

What is the best way to code this or how can this be done?

If it is a new page then the town will appear after the street.

 

If it is a new street then the town will be be displayed so this can appear on the same page. 

 

An example would be as follows

 

Page 1

High Street

Manchester

 

High Street

High Street

 

Main Street

Leeds

 

Main Street

Main Street

 

Page 2

Main Street

Leeds

 

Main Street 

 

I am getting the records from an view from a database connection. 

 

Hope this helps.