Print the last record on the page in the page header

[ProfReynolds]

I'm preparing a membership directory (similar to a phone book). I need to print the first and last name in the page header. First name in the header is easy; last name in the footer is easy too. How to get the last name into the header - that's the killer.

 

[hacoca]

One thing you can do is make a running total, and supress it. Then create a summary that pulls in the maximum value. You should be able to reset the running total on eachpage, but that might be easier said than done.

 

[Madawc]

With groups, you could use a summary total, Minimum and Maximum. But you're talking about pages, Crystal insists on handling that itself and won't give you information.

Running totals don't show anything in headers, they run along as the report prints.

You may not be able to do it in the header, in part because you won't know what's the last record on the page.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10