Any suggstions ?
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.