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

 

 

 

 

 

 

 

 

 

 

 

 

 

When you export, it has to run the subreport for every page as it's exporting the data.  Each instance of the subreport (ie, for each person on the report) is a separate query against the database.  If you have 37711 nodes in the group tree, this probably means that the subreport runs 37711 times for the export.

 

If you can format the review data to appear correctly in the details and/or a new group on the main report without using a subreport, that should speed up the export significantly.

 

-Dell