Record being missed between pages 2

[mbradley]

I have a report which lists names and sales values but removes duplicate names giving totals where people have more than 1 sale e.g.

(detail)1 Smith           50
(detail)2                140
(grp footer)             190 (total)
(detail)3 Jones           75
(detail)4 Allan          120
(detail)5 Walker          46
(detail)6                 15
(grp footer)              61 (total)

When then page ends on record 6 the total appears on the second page but when the page ends on record 4, the first record on the next page is 6 yet the total is still using records 5 and 6. All the sections fit and are not being surpressed.

This appears to be a crystal bug but is there any way round it?
Thanks in advance
Michelle

 

[lbass]

I think you must have a conditional suppression on your group footer based on a count of name, although that shouldn't cause the problem.

Anyway, I had a similar problem with a disappearing detail at the top of a page, and I was never able to trace what was causing it, but did come up with a work-around solution that worked, and which involved inserting another detail section. Take a look at thread 149-394032 for details. Maybe that will help.

-LB

 

[mbradley]

Thanks lbass. I looked at your previous thread and inserted a blank details section (and suppressed it) above my other details and this worked! A very strange solution to the problem but my report now shows all the records thanks again.

Michelle

 

[mbradley]

I thought I'd update this thread as it turns out adding a blank detail line did not fix my problem.
I re-read the thread suggested and found that my detail section was set to underlay following section (not necessary for the report) and when I removed this the missing detail re-appeared.

Thanks again for your help
Michelle

 

[lbass]

I'm glad you were able to solve the problem. I had "underlay following section" in my report, too, but needed it. My solution, by the way, relied on inserting a detail section that was NOT suppressed or blank.

-LB