Report Performance - Multiple Sub, Sub-Reports

[WANNABE]

Hello, I've posted a question in <microsoft.public.access.reports> and it seems
there may be less activity there so I am posting this to ask that someone who
knows about Access 2003 Report performance, please locate my post over there and
reply. Thank you.

The Subject is a little different, look for "Multiple Sub, Sub-Reports - Report
Performance"

 

[Tony Toews [MVP]]

Hello, I've posted a question in <microsoft.public.access.reports> and it seems
there may be less activity there so I am posting this to ask that someone who
knows about Access 2003 Report performance, please locate my post over there and
reply. Thank you.

I generally don't monitor that newsgroup so thanks for the message
here. I've responded there but you won't like my answer as it means a
lot of VBA code.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[WANNABE]

Thanks Tony, This is very Helpful, I've also learned that using "Page of Pages"
Extends the amount of time for a report to run by nearly 15 times.
============================================

Hello, I've posted a question in <microsoft.public.access.reports> and it seems
there may be less activity there so I am posting this to ask that someone who
knows about Access 2003 Report performance, please locate my post over there
and
reply. Thank you.

I generally don't monitor that newsgroup so thanks for the message
here. I've responded there but you won't like my answer as it means a
lot of VBA code.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

Thanks Tony, This is very Helpful, I've also learned that using "Page of Pages"
Extends the amount of time for a report to run by nearly 15 times.

15 times? Yowzer. I would've thought only doubled.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/