Crystal Reports Multiple Grouping Issues

Message

   CRYSTAL VERSION: 9

Apolagies if this is somethinga lready asnwered to death but I can't find an answer to this myself.  I alos alogaize if this doesn;t make sense as I have tried several re-writes to properly articulate this isue; an issue that is easy to show when vieiwng the actual report but hard to describe.

In order to properly show what is happeneing I'm going to use dummy data in teh form of an outline.

My problem is with having the header of an outer group appear on a page byitself when the next groups data is more then can fit on the remaineder of the page that the group 1 header is on.  I can't simply disable the KEEP TOGETHER Group setting because then I'd end up also having a case where I get an orphan Footer for Group 1 by itself when part of the Group under it on the prior page shoudl have been moved forward one page and paired with the footer.

//This is what I should get 

GRP1 - HDR
  GRP 2 - HDR
     GRP3 - HDR
       DETAIL LINE 1
       DETAIL LINE 2
     GRP3 - FTR
   GRP2 - FTR
GRP1 - FTR
<----PAGE BREAK---->

GRP1 - HDR
  GRP 2 - HDR
     GRP3 - HDR
       DETAIL LINE 1
       DETAIL LINE 2
     GRP3 - FTR

<----PAGE BREAK---->
   GRP2 - HDR
     GRP2 - HDR
       DETAIL LINE 1
     GRP3-FTR
   GRP2 - FTR
GRP1 - FTR
<----PAGE BREAK---->

//This is what actuall is happening

GRP1 - HDR
  WHITE SPACE
  WHITE SPACE
  WHITE SPACE
<----PAGE BREAK---->

  GRP 2 - HDR
     GRP3 - HDR
       DETAIL LINE 1
       DETAIL LINE 2
     GRP3 - FTR

<----PAGE BREAK---->
   GRP2 - HDR
     GRP2 - HDR
       DETAIL LINE 1
     GRP3-FTR
   GRP2 - FTR
GRP1 - FTR
<----PAGE BREAK---->

THIS happens when the sum of GRP 2 + GRP3 is able to fit on a page without GRP1 but not when GRP1 is included.

I could turn off KEEP TOGETHER for GROUP 1 but then I will end up with Orphaned GRP 1 Footer setcions.  

And so the problme is how to get dynamic KEEP TOGETHER logic that works when the amount of data in all the groups below it can fit on the same page as Group 1 HDR and that will ignore KEEP TOGETHER when the amount of the data in all the Groups below it is more then will fit on the same page as the Grp 1 Header.  When that happens you split up the data in Groups 2 & 3 across multiple pages and re-print the Group Header at the top of each page until the group is complete.

This is very difficult to epxlain in words bvut very easy to see in the report so please let men know if more detail is neded.