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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress Group Header if it is last value in a page

Status
Not open for further replies.

kutoose

Technical User
Sep 11, 2002
169
US
I have few groups in a report and I am displaying the group header values. I am also displaying records in the detail section for that group. The issue is some cases the group header information is printed as last value in a page, and in the next page it displays the group header again with the records in the detail section. In such cases how will I suppress the group header display which comes as the last information in the page ?

I am using Crystal 9.
I am using 'Repeat Group Header on each page' option for the group.
I cannot use 'Keep Together' option for the group in section expert since it is displaying many blank spaces.

Thanks !
 
Right click the Group and select change group->Keep Group Together.

You can't really have it both ways, either you keep the group together or you don't.

-k
 
Well I need to find a solution badly ! Is there any way to highlight a last group in a page or last record in a page ?
 
Actually, there is a way to prevent "widowing" your group header, though it may be a tad uncoventional:

1) Suppress the Group Header section.
2) insert a new detail section. Position the section above the original detail section.
3) Drag the contents of the now-suppressed group header into the newly-created details section.
4) Conditionally suppress the details section, as follows. Assuming your group is based upon a field called "Field1", you formula would read: {Field1} = Previous ({Field1})
5) Lastly in the Section Expert, ensure the general details section (not Details a or Details b, but the one above it) is set to KEEP together.

This will ensure that the "Group Header" will display with at least the first row of data and thus never be orphaned.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top