Any suggstions ?
Answer
How to significantly speed up the performance of Reports ?
Best answer by BenjaminCrisman
Typically the best options are to reduce the size of the data set or run the report during off hours if possible.
Additionally, if there are lots of joins you could try to combine some of them into a custom field or SQL view and then use this instead of some of the tables, though this can’t always work.
Make sure all joins are correct and data links are as accurate and efficient as possible to reduce extra and if there are subreports, make sure these are also running as efficiently as possible
+4Typically the best options are to reduce the size of the data set or run the report during off hours if possible.
Additionally, if there are lots of joins you could try to combine some of them into a custom field or SQL view and then use this instead of some of the tables, though this can’t always work.
Make sure all joins are correct and data links are as accurate and efficient as possible to reduce extra and if there are subreports, make sure these are also running as efficiently as possible
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.