Tuesday, August 25, 2009

Crystal Reports : Speed Tips

Here are a few things I have found to help with report performance:

1. Select, from the menu, Database | Perform grouping on server. This helps against SQL Backends.
2. Constrain data using the Select Expert whenever possible.
3. Constrain against indexed fields whenever possible.
4. Whenever possible, Group on an actual database field, not on a formula.

No comments: