Page count slows report dramatically

[Brian]

I was troubleshooting a slow-opening report today and found that when I
removed the standard (wizard-generated) page count at the bottom of my
report, the report went from 22 seconds to about 5 seconds to open.

Page footer page-count text box has this ControlSource ="Page " & [Page] & "
of " & [Pages]

Why is this? Does Access not calculate the number of pages without this
reference being on the report? Is there an alternative?

 

[Brendan Reynolds]

Access has to format the report twice when you use Pages - once to figure
out how many pages there are going to be, the second time to go back and put
that number into the expression.

I'm not aware of an alternative, if you really need the number of pages.
(It can be quite valuable, as without it someone could potentially draw the
wrong conclusion from a report because it may not be obvious that pages are
missing.)

 

[fredg]

I was troubleshooting a slow-opening report today and found that when I
removed the standard (wizard-generated) page count at the bottom of my
report, the report went from 22 seconds to about 5 seconds to open.

Page footer page-count text box has this ControlSource ="Page " & [Page] & "
of " & [Pages]

Why is this? Does Access not calculate the number of pages without this
reference being on the report? Is there an alternative?

It's not the [Page] that is slowing the report it's the [Pages].
In order to determine how many total Pages there are in the report,
Access must format the report twice. Once to get the count of the
total number of pages, then a second time to actually print or display
the report.

 

[Brian]

Yeah, I discovered that by taking out the entry piece-by-piece. It makes
sense, though, so I can't really complain.

I was troubleshooting a slow-opening report today and found that when I
removed the standard (wizard-generated) page count at the bottom of my
report, the report went from 22 seconds to about 5 seconds to open.

Page footer page-count text box has this ControlSource ="Page " & [Page] & "
of " & [Pages]

Why is this? Does Access not calculate the number of pages without this
reference being on the report? Is there an alternative?

It's not the [Page] that is slowing the report it's the [Pages].
In order to determine how many total Pages there are in the report,
Access must format the report twice. Once to get the count of the
total number of pages, then a second time to actually print or display
the report.

 

[G2]

Has anyone else found a solution to this problem since this was originally
posted?

G2

Access has to format the report twice when you use Pages - once to figure
out how many pages there are going to be, the second time to go back and put
that number into the expression.

I'm not aware of an alternative, if you really need the number of pages.
(It can be quite valuable, as without it someone could potentially draw the
wrong conclusion from a report because it may not be obvious that pages are
missing.)

--
Brendan Reynolds

I was troubleshooting a slow-opening report today and found that when I
removed the standard (wizard-generated) page count at the bottom of my
report, the report went from 22 seconds to about 5 seconds to open.

Page footer page-count text box has this ControlSource ="Page " & [Page] &
"
of " & [Pages]

Why is this? Does Access not calculate the number of pages without this
reference being on the report? Is there an alternative?

 

[Douglas J. Steele]

Brendan was being coy. If Brendan's unaware of an alternative, odds are
there isn't one.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Has anyone else found a solution to this problem since this was originally
posted?

G2

Access has to format the report twice when you use Pages - once to figure
out how many pages there are going to be, the second time to go back and
put
that number into the expression.

I'm not aware of an alternative, if you really need the number of pages.
(It can be quite valuable, as without it someone could potentially draw
the
wrong conclusion from a report because it may not be obvious that pages
are
missing.)

--
Brendan Reynolds

I was troubleshooting a slow-opening report today and found that when I
removed the standard (wizard-generated) page count at the bottom of my
report, the report went from 22 seconds to about 5 seconds to open.

Page footer page-count text box has this ControlSource ="Page " &
[Page] &
"
of " & [Pages]

Why is this? Does Access not calculate the number of pages without this
reference being on the report? Is there an alternative?