Group Headers appears at the bottom of the page. 1

[sds786]

Hello Sweet Fellows,
I am working on Crystal 11.5 and Oracle database/Universe, I have grouping in the report but on some pages group header appear at the bottom the of the page without any detail record which looks weird. I also have set option ‘repeat headers on each page’, but I don’t need group header at the bottom of the page.
I tried some previous threads but did not work, I will appreciate any help.

sds

 

[elsenorjose]

This works:

http://tek-tips.com/viewthread.cfm?qid=905801&page=1

 

[sds786]

Thanks elsenorjose for your help, it worked well.

 

[sds786]

Hello elsenorjose and all other experts,
I am back again, actually when I checked all pages of my reports I noticed that the groups contian only one record in detail also suppressed, I think that's is becuase of {#RTRowCount} = 1 //modify with your RT field,
any solution to solve this issue?

Thanks.
sds

 

[Madawc]

Have you tried 'Keep Group Together'? That wastes a bit of space but does avoid 'orphan' group headers at the bottom of a page.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

I'm not following. Are you saying that the group header AND the detail are suppressed for groups containing only one record? Do you have a suppression formula for the group header?

-LB

 

[sds786]

Thanks Medaws and Ibass for your response,
Here is some more details; Actually Group header which appears on the last line of the first page is suppressed (that's what I am looking for) but on the next pages those records having only one record in detail section they are suppressed only the details sections but only group headers appears there, it means two group headers appears together, here are the exact text of that thread which I applied,

1.Create a Running Total field. Set it up to summarize a field in your details, summary type should be Count,
2.Evaluate each Record, and Reset on change of your Grouping. Place somewhere in your details section.
3.Change your Group to only "Repeat Group Header on Each Page", and not "Keep group Together".
4.Insert another Group Header section. You should now have a Group Header A and a Group Header B.
5.Copy all your detail fields, and paste them into Group Header B so that they line up with the fields in the detail section.
6.Next, go to Report, Section Expert. Highlight Group Header (not A or B, but the parent one above A) and select the property "Keep Together".
7.Next, highlight Group Header B, and click the X+2 button next to Suppress (No Drill Down).
Enter the following line into the editor: inrepeatedgroupheader - Click Save and Close.
8.Next, highlight Details and click the X+2 button next to Suppress (No Drill Down).
9.Enter the following line into the editor: {#RTRowCount} = 1 //modify with your RT field
You can suppress the RT field(s) on the report if you want.

 

[lbass]

You could try my solution in the same thread.

-LB

 

[sds786]

Thanks LB, sorry for delay in my response, actually I was busy in other priority task and could not manage time to check that, but I will definitely check asap and post my findings.