gh1 - state

gh2 - city

 

gf2 - sub total

gf1 - total

 

I am trying to get  a new page after gf2(as long as it isn't the last group) and after gf1. the problem is it then creates a page with nothing but a gf1. I have tried mixing and matching the not onlastrecord option but nothing seems to work. so i have tried

 

gh1

gh2

 

gf2 - new page after not onlastrecord

gf1- new page after

 

 I would think this would have been asked before but couldn't find a posting.

 

thanks for any help.

 

the issue is i want to see (assuming there are only two cities in Ohio)

Ohio

  Akron

      detail

  Akron sub total

 

  Cleveland

     detail

   Cleveland sub total

Grand total for Ohio

 

doing it with headers or footers doesn't seem to make a difference... it just

 moves where the blank page is

 

 

or