Print Page | Close Window

Keep Details section together

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21104
Printed Date: 05 May 2024 at 4:58am


Topic: Keep Details section together
Posted By: GrisCorp
Subject: Keep Details section together
Date Posted: 13 Oct 2014 at 5:25am
I am using Crystal Reports XI R2.

I have a report that prints all the work orders for our shop.  I have one Group and it has 22 Detail sections.  In one of those Details sections I have placed a Text field with the name of the section, Packaging.  I then have several more text objects containing db fields that will print in that section if there is data in them for the product selected.  I have sized the height of the text objects containing the db fields to only show one line and set it to 'Can Grow'.  I have also set it to suppress embedded field blank lines.

The problem I am having is that depending on the number of fields with data in them, the section often breaks across the page so I end up with "Packaging" at the bottom of the page and the text objects containing the packaging info prints on the following page.

I have selected 'Keep Together' in the Section Expert, but it does not make any difference.

I want to keep this Details section together and have it move the entire section to the second page rather than break it.   How can I accomplish this?


Replies:
Posted By: z9962
Date Posted: 13 Oct 2014 at 5:43am

go to the change group options, under the options tab select keep group together.  

Posted By: GrisCorp
Date Posted: 13 Oct 2014 at 5:57am
That's selected. It still does not keep the Details section together.

Posted By: DBlank
Date Posted: 13 Oct 2014 at 7:06am
right click on the text field that grows
select format text
select Common tab
make sure the 'Keep Object Together' option is set to True

Posted By: GrisCorp
Date Posted: 13 Oct 2014 at 7:13am
That option is checked.  It is keeping the text object together; just not the Details section.

Posted By: DBlank
Date Posted: 13 Oct 2014 at 7:22am
Do you mean more multiple rows (detail prints) in a single grouping?
Then that is handles by the item z9962 mentions.
If you mean something else please explain more.
Thanks

Posted By: GrisCorp
Date Posted: 13 Oct 2014 at 9:34am
I have five text objects in one single Details section I call Packaging. 

It looks like this:
Packaging:
     Text Object 1     Text Object 2     Text Object 4     Text Object 4

The word 'Packaging' above is also a Text Object.  Text Objects 1-4 have formulas in them that may or may not result in data depending on the product being produced and options set in our ERP.

The problem I'm running into is this:
If sections above the Packaging section have enough data to push it too close to the bottom, then CR prints 'Packaging' near the bottom of the first page and prints Text Objects 1-4 (the actual packaging information) on the second page.

I need to know how to keep this one Details section together so it does not break onto the next page.  I don't care if CR pushes the entire section to the next page if there is not enough room on the first page, I just want the section to remain intact.

Posted By: DBlank
Date Posted: 13 Oct 2014 at 10:19am

do you have a grouping? Do you have any other detail sections?

Posted By: GrisCorp
Date Posted: 13 Oct 2014 at 10:36am
I have one group and 22 Details sections.  This section is #20, Details t.

Posted By: DBlank
Date Posted: 13 Oct 2014 at 10:47am
I do not think there is a setting per se.
try and expand the upper text box with "packaging:" to be the height of the text plus tee height of the first line of the Text Object 1 (if it existed) so they actually overlap some. Make sure it is set to keep object together.

Posted By: GrisCorp
Date Posted: 14 Oct 2014 at 7:48am
Expanding the Text Object with "Packaging" in it to overlap Text Object 1 did the trick.  It now pushes the whole section to the next page if there is not enough room at the bottom.

Thank you so much for your time and help, DBlank!


Print Page | Close Window