Disappearing record after repeat group header

[lbass]

I have a report (8.0) with five groups, many running totals, details "a" and "b" sections, and large group and report footer sections for summary data. Since the details can print for many pages, I have put in repeat group headers for the first two groups, and on the first group only, "Keep group together" is checked.

The problem is that the record that should display below the repeat group header is missing. By navigating back and forth through the report, it will sometimes reappear (magically!), but if I save the report, it disappears again.

My running totals are accurate, and are counting the missing record, and the record also is listed in the group tree. Last spring I had trouble with inaccurate running totals, which I discovered when exporting to Excel (where the correct totals appeared). I installed the recommended patch to fix this, and it worked.

I tried eliminating the repeat group headers and the Keep Group Together, and it initially seemed to work, but then when I saved the report, a record disappeared again. I really want to keep the headers in anyway.

I am using a very small font (6), and I noticed that the designation to the left of the detail section doesn't say Da, although Db appears where appropriate. I'm also using the can-grow function for some fields.

I've worked and reworked this report. Is it possible that I just have some corruption? I'm stymied. Any help much appreciated!

 

[SmpTraining]

Corruption is a possibility - I've had that on several occasions in the past.

Da would not show if it was set to underlay following sections. Have you checked this?

Also make certain you don't have a conditional suppression set against Da. Failing that, it may be quicker to rewrite the report (although that doesn't sound like a small job!). Steve Phillips, Crystal Consultant

 

[lbass]

Thanks, Steve. Your comment about the underlay reminded me that detail b for a particular record was appearing at the top of the page when detail a didn't (with underlay following section clicked). I think the repeated group headers may be snagging space from detail-a sometimes--perhaps a glitch in Crystal?

I checked the conditions under which the disappearing record occurred more carefully. When I open the report with saved data, there is no problem, but if I change one feature, say the format of the date in the header and then save it, the detail record at the top of the page disappears in some cases.

I think this workaround works--in case anyone else has this problem:

Insert a new detail-a so that it is a blank section above the former detail-a (now detail-b). Suppress blank section. In the case of one-to-many relationships, this creates multiple detail-a displays.

Enter a field in detail-a as a place-holder and suppress if duplicated to eliminate repeated detail-a. Change the font on this field to white so it doesn't display (if you suppress the field, this no longer works).

Resize your detail-b and detail-c sections to reduce white space (if necessary), since detail-a will now act as white space.

The repeated group headers now use space taken from "dummy" detail-a, allowing all real records to appear.

If anyone has a simpler solution, I'm interested in learning about it!

 

[lbass]

Oops. Just realized the repeat group headers couldn't have been the problem, since removing them didn't make a difference. However, whatever the source of the problem, the solution above seems to work. Now the formerly missing record appears on the top of the page. However, looking at the report as a whole, the last record from a previous page might or might not appear a second time on the top of the following page--which doesn't really matter much, but still I wonder why!