Report takes a long time to retrieve records

[samson123]

I am using CR XI, Access 2000

I have a main report and three subreports in the detail sections (Db, Dc, Dd).

Contact Name, Company are stored in CONTACT table
Address info stored in ADDR table
Phone info stored in PHONE table
Email info stored in EML table


It is basically a Contact Address report where I have a Person's Name, Comapny Name in Section "Da" . (Underlay following section checked)

Address Info comes from subreport in Db
Phone Info comes from subreport in Dc
Email info comes from subreport in Dd

When I retrieve records (say 1700 contacts) it takes a long time ( close to 3 - 4 minutes) to show the report.

What can I do to improve the performace ?

 

[Turkbear]

Hi,
Why subreports?( They are inefficient and should be used only when necessary).
Can't you just join the tables ( or create a view in the database that does the join) and just use that for the report?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

I work on a database where an account will have customer details and and may also have account address details. The accounts are given an equal join to the customer, but a 'left outer' to the account address details. Then I write formula fields, things like

if not isnull({ACCADD.Street})
then {ACCADD.Street}
else {CUST.Street}

As Turkbear says, subreports are inefficient. The main report makes one request to the server for all of the records it needs. A subreport in a detail line makes a separate request for each detail line, whcih means it can take forever.

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10