Group header taking up entire page, sometimes 1

[pdankert]

I am working in Crystal 8.5. I have a group header that works fine 90% of the time. On certain records the group header will display and the rest of the page will be blank. Starting on the next page the detail section will display. I know that this is the group header because I have added a test field and another header before the detail section and this too will print on the next page. I need to stress that this does not happen to every record.

Any suggestions would be appreciated. Thanks.

 

[vidru]

Try one of these:
1) Right click on your group header, go to 'Change Group', and uncheck 'Keep Group Together' (if it's checked).
2) Right click on your group header, go to 'Format Section', and uncheck 'Keep Together' (if it's checked).

-dave

 

[pdankert]

I have neither of these checked. Thanks though.

 

[Ngolem]

you haven't given us much to go on. What is different about the records that give you the funny Group header?

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[kenhamady]

The problem is probably with the detail section. Maybe it has a large object in it that won't fit on the page, or maybe there is a page break that kicks in based on a formula. I would look at the formatting properties of both the GH and whatever is following it.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[Madawc]

pdankert, if you want the group header on the same page as the group detail line, then you should have 'Keep Group Together' checked.

The drawback is that when the first group in a report is more than one page long, it will be printed on Page 2, regardless. I don't think there is any way round this in Crystal 8.5.

Madawc Williams
East Anglia, Great Britain

 

[pdankert]

I have also tried "keep together", that doesn't change anything.

There is no difference between the funny group header info and the rest of the headers, the difference is only in the detail section. This particular record will print 2 pages of info, where most just print a couple of lines. But I have other records that print 2 pages worth of info, and those display as intended.

I have no formulas that force page breaks either.

Thank you all for your suggestions so far.

 

[Naith]

I suspect that Ken has most likely already given you the solution here.

Have you inserted any objects into your details section - like an ole object, or more likely a subreport that expands depending on the number of rows returned? If so, right click the object, and uncheck the Keep Object Together option.

If you are convinced that this problem relates to the group header, the sure way to test would be to insert a group header b, move your group header data to this section, suppress your original group header, and re-execute the report.

Naith

 

[pdankert]

I have not inserted any objects or subreports in the group header or detail sections.

As you suggested, I tried inserting a group header b, and moving header data to this section. I received the same results. Though, I also put a text object to test in the header b, and left original data in header a. The test text object in b printed just below header a, where it should. Then it was followed by a the rest of the page blank again. And on the next page the same group headers a and b printed again along with the data related to the data from the group header, as usual.

 

[Ngolem]

Why play "20 questions" with us....we are guessing at your problem....post an example of what is happening and your report structure....

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[pdankert]

Sorry, I really do appreciate the help, I will try to provide more info.

1. The page and report header are generic, don't change.

2. The group header contains info that may or may not change(see #5), Order#, cust name.

3. The detail section contains unique info based on group header. Customer PO#, items on PO.

4. The group header will reprint on the top of each page, under page header, if it needs to (data carried over to next page).

5. The group header will print whenever the order# from the group header changes, or if the customer po# from detail section changes(there can be multiple customer po#'s for each unique order#).

6. The problem is that occasionally the group header will print on the top of a page, but no detail will print on that page. The same group header will print on the top of the next page, and include the detail section as it should. The only difference I can see is that this only seems to happen with orders with alot of items on it, but again, not every large order does this.

It seems like a formatting issue, but I just don't know. Thanks again for any suggestions.

 

[Ngolem]

it is getting a little clearer

You have said what information is included in the Group header but NOT what the group is based on..is it Order# or Cust Name...or something else

to satisfy Item #4 above you go to Change Group and enable the "repeat group header on new page"

this is a confusing statement

5. The group header will print whenever the order# from the group header changes, or if the customer po# from detail section changes(there can be multiple customer po#'s for each unique order#).

It all falls back on my earlier question "What is the Group based on???" How are you accomplishing the second part of this statement???


Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[pdankert]

The group is based on Order #.

The second part of that statement is accomplised by sorting the report by fields.
The report sorts by:
Order # (in the group header section)
Customer PO# (in the detail section)
Line # (in the detail section)

 

[Ngolem]

Order # (in the group header section)
Customer PO# (in the detail section)
Line # (in the detail section)
********************************

Well Order# is already sorted given that it is already grouped...hopefully that is what you mean by the above..if you added the field to the record sort Remove it.

As far as Customer PO# is concerned...this is really another grouping not a sort value.

I would create another group based on Customer PO#

If you want the Group #1 (Order#) information to repeat here...place all the fields that you would normally have in the Group 1 placed in the new Group 2 header and completely suppress the Group 1 header...for group 2 make sure you enable the "repeat group header on new page"

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[pdankert]

Jim,

Your suggestion to move the info to another Group header seems to have done the trick. Thanks so much for your help, I really appreciate it!