Can someone help me out here?

I have created a report using Report Manager from the front end. N
problems here! The report consists of 4 views - each 1 page long whe
printed. These views are created programmatically using VBA. Th
headers and footers are defined and set on the views. One of th
footers of each of these views is intended to show the page number i
the "Page 'x' of 'y'" format.

When individual views are previewed or printed, the page number
show/print correctly as Page 1 of 1. However when the whole report i
printed (a total of 4 pages - remember the report consists of 4 view
each 1 page long), with the "Use Continuous Page Numbers" check bo
ticked on the appropriate Report Manager dialog box, the printed repor
shows the page numbers as

"Page 1 of 1" on sheet1
"Page 2 of 1" on sheet2
"Page 3 of 1" on sheet3
"Page 4 of 1" on sheet4

on the appropriate footers. So whilst the page numbers on th
individual sheets are correct, the total pages in the report is not.

How can I get the report to show the total number of pages in th
report as against the total number of pages in the views?


Best regards


Deepak Agarwa

--
Message posted from http://www.ExcelForum.com