Skip to Content
Former Member
Jul 21, 2016 at 12:15 PM

Export to excel optimization


Dear All

We are trying to run some exports to excel created in crystal report

and we have tried to optimize the process using indexes, materialized views and hints to avoid crossing during the query.

After the changes we do not get an improvement yet and we believe that is due to the volume of data.

How can we optimize the reports to get an acceptable answer?

In case that optimization was not possible.......

Which technical solution should we apply in order to get the excel (asynchronous executions, ....)

Thank you very much

Best regards.