Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Orphan Group Header on next page

Orphan Group Header on next page

Crystal 8.5

I'm writing a report of standardized testing data for the students enrolled in each teacher's classes. The report is grouped by:

Group #1 - school id#
Group #2 - teacher name/number (combined)
Group #3 - course number (Course 1141)
Group #4 - Course section number (Course 1141, Section 01, 02, etc)

The details section is made up of a subreport showing each student's scores, grouped by the student ID. The student ID is also the link field between the subreport and container report.

All of this to set up the problem: I have a page break in the footer for Group #4 (which means that every time a new class/section period starts, a new page starts). I also have the teacher name repeating on each page. The repeat of the teacher name is the problem.

When the page breaks to the new teacher, the previous teacher's header prints (with nothing else under it). I know I need some conditional suppression, but I don't know exactly what to evaluate since the detail is a subreport.

Thanks for any suggestions.

RE: Orphan Group Header on next page

It sounds like you have some blank space within the subreport (the report footer?) or in the main report, e.g., group footers. Look to the left just below where the extra group header is printing to see what report section is creating this space. Try looking in design mode, and then suppress the blank sections and see if it resolves.

Another possibility is that you have set both new page before on the group header and new page after on the group footer--you only need one of these.


RE: Orphan Group Header on next page

The subreport has everything suppressed but the header and details. No extra space there.

I checked, and I have force new page after on the footer of the teacher section, not on the header.

Very frustrating because it seems like it would be something simple!

Thanks for the suggestions. . .

RE: Orphan Group Header on next page

And do you have blank, unsuppressed sections in the main report, e.g., GF sections? In design mode, also make sure the subreport is tight up against the horizontal section borders. Also format the detail section to "suppress blank section"--you might have cases where the sub is not executing, but the detail space is reserved.

Did you check what report section is displaying in the gray area to the left of the report canvas just below the orphaned group header? What was it?


RE: Orphan Group Header on next page

The section to the left of the orphaned header is GH2.

It shows:
GH2 (the orphan header)
GH2 (the new section)
GH4 (I have GH3 overlaying GH4)

The detail section is tight against the sub report; all sections are set to suppress when blank.  AARGH!


RE: Orphan Group Header on next page

I actually meant to the left of the blank area. What do you mean by "the new GH2 section"? I thought you said you were getting ONLY blank space below the orphaned group header.

Try formatting all of the sections you mention in your last post to "suppress blank section."

Also, as an aside, it seems to me that you should be linking your sub on the student ID, AND the course ID, so that you don't end up showing grades for the wrong course.


RE: Orphan Group Header on next page

First, on the linking question:  that would be happening if this were "regular" grades, but this is state standardized test scores, which are referenced only by the student ID (don't get me started on that)!

Second, I went back and re-read my original post; I may not have been clear.  There is no space after the orphan teacher header.  The orphan header appears, then right below it the header for the change of course/section.  Where the problem is happening is where the change of course/section happens at the same time the teacher changes.  

RE: Orphan Group Header on next page

Can you show a sample of what you mean, please? Are you suppressing any records? If so, what sections are suppressed and what are your criteria?


RE: Orphan Group Header on next page

Page attached. . .

The following sections have blanks suppressed
GH2 (teacher)
GH3 (course)- this overlays GH4 (section)

The following are suppressed [b]completely[\b]
GF4 - New page after


RE: Orphan Group Header on next page

Your attachment doesn't work.


RE: Orphan Group Header on next page

I'm going to have to use the report as-is.  Unfortunately, with school starting in three days, there are too many requests and not enough time.  Thank you for your suggestions.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close