Hi all,
I have what I consider to be a fairly simple report which takes about 15 seconds to run but is taking about 90 minutes to export to any format.
GH1 - Person ID
GH2 - Conference Date - a formula to show the next conference date is also shown in this group. This gives me a date period which I then pass into a subreport.
D - Subreport - Shows all reviews that have happened in the date period passed through from GH2 (most records will have approx 3-5 reviews)
Can anbody suggest what might be the reason why the report is taking so long to export.
Some of the data from the Performance Information screen in case that helps....
Saved Data
Total number of records 21254
size of saved records 23mb
Processing
Grouping on database server - No
Sorting on database server - No
Record selection done on database - Yes
Require two passes - Yes
Page Count - No
Nodes in Group Tree - 37711
Summary Values - 0
Size of Group Tree - 1mb
Built group tree in progress - No
Performance Timing
Open Document - 3236ms
run database query - 19459ms
read database records - 1175ms
format first page - 21594ms
pages formatted - 1
average - 21594ms
Hopefully this is enough information for somebody to spot what might be wrong. I am happy to provide more if needed.
Many thanks
Chris