When add subreport to main report - very slow!

J

JKro

I have a main report and a subreport. The main report is really just a
container for the subreport (it has some header information that I was unable
to put on the subreport) so the main report reads a single record from a
table with one record in it. It takes <1 second to run.

The subreport also reads from a small table (about 30 records) but it is
formatted in such a way (it ends up looking like a calendar) that it takes
about 5 seconds to run.

However, when I put the subreport on the main report and link them by a
single id field, the main report now takes about 15 seconds to run.

Anybody have suggestions on how to speed this process up?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top