Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub Report CANNOT GROW!!!

Status
Not open for further replies.
sskrobe

sskrobe

Technical User
Sep 10, 2003
11
US
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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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...

-LB
 
Upvote 0 Downvote
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???
 
Upvote 0 Downvote
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.

-LB
 
Upvote 0 Downvote
How can I go about suppressing the page footer on my report header?
 
Upvote 0 Downvote
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

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

A Beginner
  • Locked
  • Question
is the RDC still available in Crystal Report
Replies
1
Views
419
hilfy
hilfy
hpl2001
  • Locked
  • Question
Report in History auto updating
Replies
0
Views
237
hpl2001
hpl2001
rwn
  • Locked
  • Question
Crystal Report Parameter Screen - Unable to Click Buttons - - CR2008
Replies
0
Views
275
rwn
rwn
eknight1010
  • Locked
  • Question
Seagate Info Desktop 7.5 - Can't view reports 5
Replies
15
Views
701
eruji
eruji
Maikyy
  • Locked
  • Question
[Crystal SQL Designer] Crystal Reports 7
Replies
0
Views
295
Maikyy
Maikyy

Part and Inventory Search

Sponsor

Back
Top