Keep Together

[Former Member]

I have a report with a Group Header 1a with Company Name.... and Group Header 1b with some formula results..... details section is suppressed.

In some cases GH 1a is at end of page 1 and corresponding data (GH 1b) is on page 2.

Is there a way to push company name to page 2 if corresponding data will not fit on same page?

I hope I explained this well enough.

[Former Member · Accepted solution]

Make sure the Group Header section is marked Keep Together in the Section Expert - NOT the underlying sections (Group header a, group header b, group header c, etc.)

OR you can go to Change Group for the group itself and under the options tab mark "Keep Group Together"

There is a kbase on the different keep together options (Keep Section Together, Keep Object Together, Keep Group Together). Good article!

See below!

Enjoy!!!!

Symptom

In the Crystal Reports (CR) Designer, how do the different 'Keep Together' options affect the report?

The 'Keep Together' options in CR are as follows:

• Keep Together

• Keep Group Together

• Keep Object Together

• Keep Columns Together

Where do you find the 'Keep Together' options in CR and how do they affect your report?

Resolution

The 'Keep Together' options are available to format objects and sections of the report. The 'Keep Together' options affect how the report displays the particular object or section.

Based on the report sections and commonly used report objects, this article provides the following:

• Where to find the 'Keep Together' options

• Example report details

• How the report is affected based on the example report details

Report sections and commonly used report objects that include the 'Keep Together' options:

A) Report Header/Report Footer, Group Header/Group Footer, Details

B) Group Options

C) Subreports, Text Objects, Ole Objects, And Other Database Fields

D) Cross-tabs

A) REPORT HEADER/REPORT FOOTER, GROUP HEADER/GROUP FOOTER, DETAILS

To locate the 'Keep Together' option for the different sections of the report, follow these steps:

1. Click Format > Section.

2. In the Section Expert, select the section.

3. Under the Common tab, select 'Keep Together' check box.

==========

NOTE:

'Keep Together' is unavailable for the Page Header and Page Footer sections. This is by design. Each Page Header and Page Footer is already designed to keep together at the top and bottom of each page.

==========

When the 'Keep Together' option is selected, CR keeps the entire instance of the particular section on the same page.

EXAMPLE REPORT DETAILS:

• The Group Footer is three inches in height.

• The 'Keep Together' option is selected for the Group Footer section.

• There is only one inch available at the end of the page.

Based on the EXAMPLE REPORT DETAILS, the entire Group Footer section will begin at the top of the next page.

==========

NOTE:

Do not use this option if your intention is to keep the entire group together. Use the 'Keep Group Together' option as described in B) GROUP OPTIONS.

==========

B) GROUP OPTIONS

To locate the 'Keep Group Together' option for inserting or changing a group, follow these steps:

1. Click the following options depending on whether you are inserting a new group or changing an existing group:

• Insert > Group for inserting a new group

• Report > Change Group Expert > Options for changing an existing group

2. Under the "Group Options" heading, select the 'Keep Group Together' check box.

3. Click 'OK'.

EXAMPLE REPORT DETAILS:

• The Group Header, Details and Group Footer are displayed for each group instance.

• The amount of space required to display for a group instance exceeds the remaining space available on the report page.

Based on the EXAMPLE REPORT DETAILS, the entire group instance will start on a new page. The entire group instance includes the Group Header, Details and Group Footer.

==========

NOTE:

If the group instance spans multiple pages, 'Keep Group Together' option starts on a new page and continues through the multiple pages until the particular group instance is completed.

If more than one group instance can fit on one page, more than one group instance will display on the same page.

Do not use this option if the intended purpose is to have each group start on a new page. If the intended purpose is to have each group start on a new page, format the Group Footer section with the option 'New Page After' selected.

==========

C) SUBREPORTS, TEXT OBJECTS, OLE OBJECTS, AND OTHER DATABASE FIELDS

To locate the 'Keep Object Together' option for formatting subreports, text objects, OLE objects, and other database fields, follow these steps:

1. Right-click the report object.

2. Select the one of following available options depending on the object type:

• 'Format Subreport' for subreports

• 'Format Text' for text objects

• 'Format Graphic' for OLE objects

• 'Format Field' for database fields

3. Under the Common tab, select the 'Keep Object Together' check box.

When the 'Keep Object Together' option is selected, CR keeps the entire instance of the particular object on the same page.

EXAMPLE REPORT DETAILS

• The Group Footer contains a subreport and a text object.

• The text object is placed above the subreport.

• The subreport in the Group Footer instance exceeds the remaining amount of space available on that page.

• The Group Footer section is not formatted with the 'Keep Together' option.

• The Group is not formatted with the 'Keep Group Together' option.

• The text object is not formatted with the 'Keep Object Together' option.

• The subreport is formatted with the 'Keep Object Together' option.

Based on the EXAMPLE REPORT DETAILS, the subreport will start on a new page. However, the Group Footer instance and the text object will start on the previous page. The 'Keep Object Together' option is only applicable to the particular object.

D) CROSS-TABS

To locate the 'Keep Columns Together' option for formatting a cross-tab, follow these steps:

1. Right-click the cross-tab.

2. Select 'Format Cross-tab'.

3. Under the Customize Style tab, select the 'Keep Columns Together' check box.

When the 'Keep Columns Together' option is selected, CR keeps the columns together if a column width spans across to a second page.

EXAMPLE REPORT DETAILS

• The Report Footer contains a cross-tab.

• The cross-tab columns span multiple pages.

Based on the EXAMPLE REPORT DETAILS, the 'Keep Columns Together' option is selected, the columns that would span across the edge of the pages start on a new page. A cross-tab column is not divided between two pages.