Drilldown performance issue

Ville Aho

I'm facing some performance problems with drilldown reports.
Creating 20 page report firstly takes about minute and every time I press group to expand or to minimize it creates the whole report all over again. Needles to say it is very frustrating. Is there a way to make fields more static and prevent calculations to be repeated. I've tried artificially to prevent those by adding variable that is set after and evaluating it in fields whether it is set. Basically my report has three drilldown groups and one masterdata band. Each group header has five fields that are calculated in corresponding groupfooter. Calculated data is put on variable at first pass and on second pass read in groupheader. Similar to what is in example. Calculations in groupfooter are sum functions.
My questions are these:
Is there a way to prevent calculations or re-evaluating after the report is created?
How can I prevent showing the preview window before the data is correctly presented?
Are the aggregate functions the reason for slow opening or variable reading?

-Ville-

gpi

I think aggregate function usage doesn't decrease a performance.
Try to store query's result in temporale table and use this table as report's dataset