Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Report with Subreport VERY slow

Report with Subreport VERY slow

I have a report with a subreport that was running fine as I was building it.  I made a few changes to the report...drew some lines and a box and added a couple text boxes, all on the main report and saved it.

The next time I tried to run it the ODBC failed before it was running about 10 minutes before it failed (timed out?)

The report used to take about 30 seconds to open.  Now for the 1st 30 seconds the status bar shows, "Running Query" and shows a staus bar (it does this twice) then the status bar goes to "Formatiing Page, oress cntl + break to stop"  If I delete the subreport the main report runs fine.  There is no formatting (that I'm aware of) on the subreport.

Is there anyway to resolve this?  Are there just too many records?  There are approx 59,000 records on the main form and the system is filtering through 20,000 sub records usually only returning 1 or 2 sub records for each main record.

The database resides on SQL Server but I don't know what version.

Access 2003 SP1

Thanks for your help!


RE: Report with Subreport VERY slow

I forgot to mention that I am using an ODBC connection.


RE: Report with Subreport VERY slow

Do you add a text box with Page of Pages?

MS Access MVP
Find out how to get great answers FAQ219-2884.

RE: Report with Subreport VERY slow

Yes I did.  Is that the culprit???


RE: Report with Subreport VERY slow

That was it!  Here's a star.  I'd give you more if I could

Why does it do that?  I know I've used it before.  Is it the combination of the subreport and Page of Page?

Thank you VERY much!


RE: Report with Subreport VERY slow

Your complete report must format prior to printing the first page in order to get the "Pages". This takes quite a while with lots of records and one or more subreports.

MS Access MVP
Find out how to get great answers FAQ219-2884.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close