Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Section not "keeping together" Post Reply Post New Topic
Author Message
lynnedm
Newbie
Newbie
Avatar

Joined: 08 Jan 2008
Location: Australia
Online Status: Offline
Posts: 8
Quote lynnedm Replybullet Topic: Section not "keeping together"
     Posted: 26 Feb 2008 at 5:30pm
Hello,
 
I have a report which is composed of a lot of text fields from our data base.  Each text field needs a heading which is text object followed by  the data base field. 
 
Both the text object and the data field are in the same section with "keep together" ticked however they don't stay together.  Depending on the amount of data, the heading may print on the bottom of the page and the data on the next page.
 
Is there a forumla which can keep the text object (or heading) with the data field which follows it.
 
Thanks
Lynne
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 27 Feb 2008 at 2:16am
Hi,
 
Do you have groups in your reports.
 
Both the text object and the data field are in the same section with "keep together" ticked however they don't stay together are you talking about Groupheadings? and Data?.....
 
Cheers
Rahul
IP IP Logged
lynnedm
Newbie
Newbie
Avatar

Joined: 08 Jan 2008
Location: Australia
Online Status: Offline
Posts: 8
Quote lynnedm Replybullet Posted: 02 Mar 2008 at 3:05pm

Hi Rahul - no I'm not using groups - it's just a large free text field from the data base and a text box inserted inside Crystal  for the heading. 

I work at the Powerhouse Museum so many of our reports are based on text fields rather than numbers.  This report has a series of large text fields one after the other.  Each field need to in a separate section with it's own heading.
 
Thanks
Lynne
IP IP Logged
rvink
Groupie
Groupie
Avatar

Joined: 04 Feb 2008
Location: New Zealand
Online Status: Offline
Posts: 55
Quote rvink Replybullet Posted: 02 Mar 2008 at 4:35pm
If the text heading is unique, you could create a group on the heading. Otherwise create a group on the text. You can also sort on a group if that helps to organize your report.

On the Options tab for a group, select "Keep Group Together". Since every group will be unique and have only one record, you can place the heading and text on the group and suppress the detail section. That should do it.
IP IP Logged
lynnedm
Newbie
Newbie
Avatar

Joined: 08 Jan 2008
Location: Australia
Online Status: Offline
Posts: 8
Quote lynnedm Replybullet Posted: 02 Mar 2008 at 10:18pm
Hi again,
 
I've tried this but to no avail.   I made the heading a formula so I could select it in the group box it but even doing this and ticking  "keep together" in the Group options did not work.
 
Is there any any way of including heading and text in the one formula?
 
I'm used to writing formulas like the one below.  Can I tack insert the data field on the end of this somehow?
 
if isnull ({econserv_csv.DetReviewNotes}) then "" else "Condition on Departure from Powerhouse Museum" 
 
Thanks again


Edited by lynnedm - 02 Mar 2008 at 10:25pm
Lynne
IP IP Logged
rvink
Groupie
Groupie
Avatar

Joined: 04 Feb 2008
Location: New Zealand
Online Status: Offline
Posts: 55
Quote rvink Replybullet Posted: 03 Mar 2008 at 12:31pm
Hi Lynne,
If you have multiple groups, make sure the others don't have "keep group together" checked as they make take priority over the group you want. If that does no work, can you send the report to me with a small dataset included? It will be much easier to see what the problem is with the report in front of me. Send to roland.vink at aut.ac.nz
IP IP Logged
lynnedm
Newbie
Newbie
Avatar

Joined: 08 Jan 2008
Location: Australia
Online Status: Offline
Posts: 8
Quote lynnedm Replybullet Posted: 03 Mar 2008 at 2:37pm
Thanks for this but I've resolved this by making the field and it's heading a sub report.  It now stays together as required.
 
Thanks again
Lynne
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.