Matthew Snook
NW Salmon Database
- Local time
- Today, 19:39
- Joined
- Apr 19, 2001
- Messages
- 133
I have a report which behaves appropriately when placed into report view. I also have a query which can be attached (as a subreport) to this report using the appropriate master/child link fields. However, when I run the report with this query as a subreport I get bizarre behaviour.
The report view window arrives, blank, and the status bar goes through several states: "running query", and then "Formatting page, press ctrl-break to stop..." This state seems to last forever. When I modify my main query to include only eight or 10 records, with the same number of records in each subreport, the view will not be available for several (probably about 15) minutes. Since the complete report will contain 400+/- main records, each with several subrecords, the outcome will never come!
The subreport is based upon a crosstab query, which has the column headings property set. Is there some way to avoid this tremendous delay in running the report?
Thanks,
Matt Snook
The report view window arrives, blank, and the status bar goes through several states: "running query", and then "Formatting page, press ctrl-break to stop..." This state seems to last forever. When I modify my main query to include only eight or 10 records, with the same number of records in each subreport, the view will not be available for several (probably about 15) minutes. Since the complete report will contain 400+/- main records, each with several subrecords, the outcome will never come!
The subreport is based upon a crosstab query, which has the column headings property set. Is there some way to avoid this tremendous delay in running the report?
Thanks,
Matt Snook
