Report Generation Takes Forever

[GoatieEddie]

Hi all,

I have read through manuals but think I might need a pointer on this one.

I have a report that has two subreports, a form and an embedded chart with a linked field.

It takes AGES for the report to generate. Each of the subreports load instantaneously when I run them seperately so it must be something to do with how I am linking them.
Admittedly the subreports are generated by several queries and I wonder whether it is having to recalculate the query for each record on the master link? If I take at the complex subreport and the piechart, it works quickly so that leads me to the same conclusion

Can someone perhaps point me in the right direction as it is driving me mad!

Many thanks,
GE

 

[GoatieEddie]

Don't worry. I found dhookom's advice to someone else to remove the [Page] of [Pages] and it is now instantaneous!