Drill Through Performance

[gicy]

I have a Total, summary and detail report.

We are providing drill through functionalites to traverse back and forth from Total to summary to detail.

The only issue i have is:

On detail report:

I have a list tab, drill through to go back to summary report,
multiple value prompt, year and month filter plus 4 other filters.

I am providing a PDF and an EXECEL link that will open the detail list reports respectively.

I created a drill through on PDF link to the Detail List report using all the parameters(Six parameters actually). The report opens in a new window in a PDF format satisfying all the condition. No issue at all.

The only issue is : It takes approx. 4 minutes to open a report.
Same thing happens with Excel Link.

This is a performance problem. Can any one suggest me? Is there any workaround or alternate way of doing this.

Please let me know if you need any further information/explanation on this.

Thanks,
Gicy