Speedy way to get total number of pages in a report?

[NeilT123]

I have a report with a sub report and historically the subreport has only been 1 page so I have been able to use a record count to give me the total number of pages in the page.. of .. footer.

Some of the subreports are now stretching to 2 pages so using the above means I can get page 64 of 58 which is no good.

If I use =[pages] to get the total number of pages then typically a 62 page report takes 35 seconds to load. If I delete the =[pages] text box the report loads in 2 seconds.

Is there a speedy way to get a total number of pages when using subreports?

 

[NeilT123]

In case any one else is suffering this issue I have found a work round by basing the report and the sub reports on temporary tables. On opening the report I use SQL to populate the 7 tables and the report now loads in about 4 seconds and I am using =[pages] so the page count is correct.