|
Hi all,
Using Access 97 Front End, linked to SQL Server back end.
Required data is spread across three tables, with one table linked
one to many to the two others.
I created a report based on one child and the master (inner join),
which works properly and loads to preview in less than a second.
Created the second report using the third table, with a select
distinct clause, that also loads very rapidly.
When I insert the second report into the detail section (also tried
in a group header) of the first, linking the Foreign key in the
subreport to the Primary key of the main report, The form takes
thirty seconds to load, with the status bar text saying "formatting
page" all this time.
Once the form has loaded I have about 4 records per page. There are
about 100 records on the main report altogether, and each subreport
instance has from 1 to 5 records (without the distinct clause, I
might have 200 records on the subreport) .
The foreign key is indexed in the subreport.
Any clues as to how I can speed up the form loading?
| 
