Crystal Reports group/detail

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: group/detail

Post Reply

Post New Topic

Author	Message
huyenhall Newbie Joined: 07 Apr 2008 Online Status: Offline Posts: 7	Topic: group/detail Posted: 11 Apr 2012 at 4:54am
	Hi, I have a report with 2 groups: 1) Group 1 2) Group 2 xxx aaaa (detail) bbbb (detail) 2) Group 2 yyyy cccc (detail) dddd (detail) eeeee(detail) 2) Group 2 zzzz page 1 ffff (detail) page 2 How do I make Group 2 go to page 2 instead showing at the bottom of page 1?
	IP Logged


Keylimepie11 Newbie Joined: 11 Apr 2012 Location: United States Online Status: Offline Posts: 2	Posted: 11 Apr 2012 at 5:22am
	Under the group options, check 'Keep Group Together'. That should start a new page if the group is not short enough to fit completely on the current page.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 11 Apr 2012 at 5:23am
	open the group expert click on group level 2 and then options go to options tab mark 'Keep group Together' as True
	IP Logged

huyenhall Newbie Joined: 07 Apr 2008 Online Status: Offline Posts: 7	Posted: 11 Apr 2012 at 5:29am
	I did but it didn't work.
	Mimi
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 11 Apr 2012 at 6:00am
	if details row count under that group expands beyond the size of 1 page it will not page break. Is this the case in your data set? For clarity, this is *not* the "keep together" in the section expert, but rather in the *group* expert. That is where you made the change, correct? Also do you just want it to not orphan the group header without showing at least 1 detail row or do you really want it to 'keep togther' for the whole group? Edited by DBlank - 11 Apr 2012 at 6:02am
	IP Logged

huyenhall Newbie Joined: 07 Apr 2008 Online Status: Offline Posts: 7	Posted: 11 Apr 2012 at 6:12am
	I want it to not orphan the group header without showing at least 1 detail row. Thanks
	Mimi
	IP Logged

Jonart Newbie Joined: 02 Apr 2012 Online Status: Offline Posts: 16	Posted: 11 Apr 2012 at 5:27pm
	*Originally posted by huyenhall* How do I make Group 2 go to page 2 instead showing at the bottom of page 1? Right click on GH1 (Group Header 1) and select Section Expert. Click "New Page After". However I suspect this is not what you want. Page 1 will be mostly empty with only GH1 displayed.. Also, you will get a page break each time GH1 changes value. Jonart
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Apr 2012 at 3:42am
	here is a trcik to make sure you have at least one detail row to show with a group header (avoid orpahaned Gheaders at the botom of a page) ... add a GHa that has nothing in it make the height of GHa the height of GHb + one detail row (or more if you want) in the section expert set GHa to 'keep togther' as true and 'underlay following sections' as true your group header data should all be in group header b Edited by DBlank - 12 Apr 2012 at 3:43am
	IP Logged

huyenhall Newbie Joined: 07 Apr 2008 Online Status: Offline Posts: 7	Posted: 12 Apr 2012 at 5:18am
	It worked. Thank you so much!
	Mimi
	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