Sub reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two sub reports. One works fine but the other takes about 10 tens
minutes to run. When I run the query itself which is used as the record
source for the sub report it runs fine. When I run the main report without
the problem sub report it runs in about 3 seconds if I add the other sub
report the main reports takes about ten minutes to run. I have also removed
the the working sub report and just placed the problem sub report on the main
report but it still takes about ten minutes to run. I looked at my
relationships I can't see any problems. Please Help.
 
Mike

This is a "forms" newsgroup... try reposting to the "reports" newsgroup.

You've "looked at [your] relationships" but we don't know anything about
them.

You have a "query ... which is used as the report source..." but we can't
see it, and don't know how you've designed it (i.e., the SQL statement).

It sounds like you have a main report and two sub-reports, but how you've
related the sub-reports to the main isn't clear.

If you want more information from the 'groups, consider providing more to
help us help you...
 
Back
Top