Suppressing group header

[BrianDoric]

I am using group headers based on a data field.

Some of the groups are short and sometimes a group header appears too low on a page for there to be any space for any records to follow it.

When this happens the group header is repeated at the head of the next page.

I would like to suppress group headers that are followed by no records because of insufficient space but so far I have been unsuccessful.

I would be grateful for any suggestions.

Regards

Brian

 

[synapsevampire]

Right click the group section and select change group.

In the Options tab, select the Keep Group Together.

This will provide a break prior to the group header if there isn't room for some rows, however the report will become slightly larger as a result.

-k

 

[lbass]

First, try going to the group expert->options->check "Keep group together", and see if you like that result. If not, remove the check mark for "Keep group together" and then create these formulas (this assumes that sections are all of the same height):

//{@reset} to be placed in the page header:
whileprintingrecords;
numbervar linecnt := 0;

//{@accum} to be placed in every group and detail section:
whileprintingrecords;
numbervar linecnt := linecnt + 1;

Note the number at the bottom of the page (which must be the same for all pages).Then go to the section expert->group header->suppress->x+2 and enter:

whileprintingrecords;
numbervar linecnt;
linecnt = 60

Also for the group header, go to new page after->x+2 and enter:

whileprintingrecords;
numbervar linecnt;
not onlastrecord and
linecnt = 60

This will ensure that a detail row does not replace the suppress group header.

-LB

 

[BrianDoric]

Many thanks everyone. Very helpful.

For the record after I posted my question I discovered the following Kbase articles:-

C2000972
C2000973
C2008983

all of which provide useful information on the subject.

Regards

Brian

 

[TEM3]

I am having similar problems with CR 8.5. What and where are Kbase articles (URL please)??

 

[lbass]

http://support.businessobjects.com/search/default.asp?ref=default.asp_wwwjump

Add an article number as a search criterion.

-LB