Log In

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!

*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.

Students Click Here

Sub Report CANNOT GROW!!!

Sub Report CANNOT GROW!!!

Sub Report CANNOT GROW!!!

Ok, here is what I'm trying to do. The goal of this crystal report is to reproduce the paperwork for Canadian Custom Invoices.

I have a report that contains:
a Group Header A
a Group Header B
and a Group Header C

Group Header A (form header) is always 5 inches and must appear at the top of each page. No problem there.

Group Header C (form footer) is always 3 inches and must appear at the bottom of each page. No problem there.

The problem is with Group Footer B. This is where my sub report is located. This subreport returns a different number of rows each time (data lenght is never constant). Basically, I need to set it up so that it prints 4 inches worth of data and then if needed, put the rest on the next page and so on (still printing between Group Header A and C).

Any help?

CR 8 and 8.5

RE: Sub Report CANNOT GROW!!!

Right-click on the subreport.  Choose [Format Text] and check the [Can Grow] option.  You also decide [Keep Object Together] in this section.

Note that subreports (and anything else) will 'grow' over fields placed below them in the same section.  That's where [Insert Section Below] comes in useful.

Madawc Williams
East Anglia, Great Britain

RE: Sub Report CANNOT GROW!!!

Thanks, but that's not really what needs to be done.

Basically, I need to set the MAX LINES of the subreport so that it doesn't grow or everlap. Unfortunatly, the max lines option is grayed out on the sub report.

RE: Sub Report CANNOT GROW!!!

There is no way you can get a group header B to continue onto the next page, and still have the group header C print on the first page.  So the question is what is in "Group Header C" (which you have also described as a footer), and could it be put in the page footer?  If that's possible, then I think this is doable.

Let me know...


RE: Sub Report CANNOT GROW!!!

I did consider that, but on my Report Hearder, I have a full page that absolutly needs to be printed in it's entirety.

So if I make C the page footer it messes up my report Header.

Any ideas???

RE: Sub Report CANNOT GROW!!!

Not sure what you mean. You can always suppress the page footer on the first page if you want only the report header to print there. For more help, you need to supply info about what fields are in your sections.  Please tell us what you want each section to look like and what fields are included, so it can be determined whether using a page footer is an option.


RE: Sub Report CANNOT GROW!!!

How can I go about suppressing the page footer on my report header?

RE: Sub Report CANNOT GROW!!!

Actually, if you want only the report header on the first page, just go to format->section->report header and check "new page after."

If you want some sections to print on page 1 with the report header, but you do not want the page footer to print, go to format->section->page footer->suppress->x+2 and enter:

pagenumber = 1


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! Already a Member? Login

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