Report oddity in Header/Footer

[mcoupal]

In VFP6, I have a report that is grouped by a numeric field called Cnum. This Cnum field is showing in the header and footer of each page. It starts a new page for each Cnum grouping. In the group footing for Cnum I have to show some fields which stretches that footer to about 2 inches.

Sometimes, this causes the group's footer to be displayed on the next page without any detail records showing. When this happens, the footer of that page shows Cnum + 1 when the header says (correctly) Cnum!

Unfortunately, I can't break these Cnum groupings into separate reports (i.e., it's got to be one long report of multiple pages). I've tried using a report variable but I haven't had any luck with it. Has anyone battled this before?

 

[rgbean]

What Service Pack of VFP 6.0 are you using? I believe a similar problem was fixed in SP5.

Rick

 

[mcoupal]

I'm using Service Pack 5.

I read a recent thread in here which mentioned the use of functions stored in a .PRG file. That may work, but I assume it'll be difficult.

It's like the record pointer is moving to the next record before the first detail line is shown and thus messes up the second page footer.