B
Brian
I have a report that opens in about 5 seconds, regardless of filters (i.e.
the amount of data). It takes about 8 seconds per page for navigation,
however. I removed the page count at the bottom so it would open faster. I
suspect that the first page is faster because there is a fairly large report
header, so there is less data to format on page 1.
I understand the logic behind the page count having to format each page in
order to count them. It is, of course, very slow if the user navigates
directly from the first page to the last page.
I have already ensured that there are as few domain aggregates as possible
in the controls on the form - all the data is coming directly from the
queries except for one summary control at the bottom of the report that has
to get information from a different table, so this should not affect page
layout much.
What else can I do or to avoid on reports to speed up page navigation? I do
have a fair amount of conditional formatting (red if negative) on the report,
and the summary fields are bold. Any problem here?
the amount of data). It takes about 8 seconds per page for navigation,
however. I removed the page count at the bottom so it would open faster. I
suspect that the first page is faster because there is a fairly large report
header, so there is less data to format on page 1.
I understand the logic behind the page count having to format each page in
order to count them. It is, of course, very slow if the user navigates
directly from the first page to the last page.
I have already ensured that there are as few domain aggregates as possible
in the controls on the form - all the data is coming directly from the
queries except for one summary control at the bottom of the report that has
to get information from a different table, so this should not affect page
layout much.
What else can I do or to avoid on reports to speed up page navigation? I do
have a fair amount of conditional formatting (red if negative) on the report,
and the summary fields are bold. Any problem here?