Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keep Together Property...

Status
Not open for further replies.

dBjason

Programmer
Mar 25, 2005
355
US
CR 9

Hello,

I've got a report with 2 groupings. The first (major) group headings & data work fine. The problem I'm having is with the second.

I get occasional pages which have a group header, some data, another group header, more data, another group header, then end of page. Not good as this looks ugly because there's a group header all by itself on the bottom of the page.

So I go to the Group Expert, select my group level, go to it's options, and select "Keep Group Together" to solve my woes. This (almost) works. No more Group Header 2A on the bottom of the page(s) all by itself.

HOWEVER, now I get pages that are half-blank. Seems that with this property checked, CR will force a new page if it's starting a new group in the middle of the page and is unable to finish the group on that page. This is just as bad. To illustrate:


Without "Keep Together" checked -- Rpt. Page 22
Code:
Group Header 1
  Group Header 2
     Detail
     Detail
     Detail
  Group Header 2
     Detail
     Detail
     Detail
  Group Header 3
-- note the "Group Header 3" all by itself. Bad.


With "Keep Together" checked -- Rpt. Page 53
Code:
Group Header 1
  Group Header 2
     Detail
     Detail
  Group Header 2
     Detail
-- note the blank space


Now in the latter example, the next group has 6 detail lines. Not enough to fit all of them on the page, but enough to print the group header & 2 detail lines and continue on the next page (this is what I'm trying to do). But if I uncheck "Keep Together", I'm back to problem #1.

Any way around this????


Thanks in advance,
Jason
 
hi
check the format section and select print at bottm if it makes a difference

Durango122
Remember to used all fingers when waving to policemen :)
 
I tried both ideas (thanx to to Durango & Synapse), but they only solve problem #1 and I still end up with problem #2, that is to say I still get pages which are half-blank.


Are there other options I can look into?

Thanks,
Jason
 
Hmmmm, if you turn off the Keep Together in the group, and then make sure that the Group Header also contains the first row of the details for that group (and the details do NOT show the first row for the group), then you should never get an orphaned group header.

-k
 
Hey thanks Synapse, that actually did do the trick. I had the grouping wrong the first time around.

Thanks, Muchos Gracias, Dankeshein, and may you be blessed with the wealth of a thousand shieks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top