Automatic page numbering

We are using Crystal 10 and at the bottom of each page are using the automatic page numbering (page X of XX) . We have a report footer that only occurs on the last page of the report. When the last page contains only this footer, the automatic page numbering does not work properly. The first page says 1 of 1 and the second page also says 1 of 1. The automatic page numbering does not pick up on the fact that the report has 2 pages and generate the numbers properly. Any suggestions.Use this forumula

WhilePrinitingRecords;
Numbervar N;
N:=N+1'
And place this in Report footer