How To Speed Up Your Crystal Reports

The number one question we get from our clients: "How do I run this report faster?" Here are some ways to speed up your reports:

• Instead of grouping a field within the report, group on a formula instead. This might sound crazy, but grouping on formulas decreases the grouping time. Just add the field you want grouped to a formula and group off the formula instead.

• Turn on Sage 100 Client / Server ODBC. If you are running the Sage 100 Advanced Version, you can turn on the Client / Server ODBC. Most people do not turn this on and it should be turn on for all installations.

• Try using Subreports. Subreports can sometimes speed up reports, but can also make exporting the report a little challenging.

• Don't add tables to your existing forms (such as Purchase Orders or Sales Orders). Modify the Sage 100 .wrk tables through Custom Office. This cuts down the processing done by Crystal Reports.

• Consider Upgrading to Sage 100 Premium or replicating your Sage 100 Data to SQL. By changing the report to run against SQL, we have seen reports go run from hours to minutes.

If you have any questions, please do not hesitate to contact us. Happy to share our knowledge!