Crystal Reports running slow; are there tips to make the design of a report faster ?

[Former Member]

We are having an issue with slowness with a couple Crystal Reports within the Sage MAS ERP 200 system of modules. Can we speak with a technical person regarding any experience in dealing with the work tables that are forced upon Crystal Reports within Sage MAS 200 ?

These two reports are more complicated (sub reports, records out of order, history selection) than the rest of our reports.

Thank you

[Former Member]

Hello Tyler,

You could just check the SQL generated by Crystal and have a cross check if you can tune that in.

Also you can check below links where you can verify few things on your report if you are using the same version.

Crystal report 2008 Performance issue | SCN

Regards

Niraj

[abhilash_kumar]

Hi Tyler,

What version of Crystal Reports are you using? I have no experience with Sage tables however, there are a LOT of other things that can slow down the report and it is very difficult to zero in on the cause without looking at the report itself.

Here are a few points that you'd want to consider though:

1) Does the report Join a Command SQL to another table or another Command SQL?

2) Does the report use Date conversion functions/Crystal Specific functions in the Selection formula?

3) Does the entire selection formula translate to the 'where' clause if the report has been solely built using tables/views?

4) If the report's datasource is a Command SQL, has the prompt been used in the where clause and not the selection formula? (it should be in the where clause of the query)

5) What section is the Subreport on? If the Subreport is on a Details or Group Section, do note that it has to run for each section being printed essentially further slowing down the report. 

6) Get rid of the 'Page N of M' special field if you can?

and a few more....

-Abhilashhttps://scn.sap.com/message/16275981/edit

[DellSC]

Another one that I found at a client last week:

Are you using a Group selection formula instead of or in addition to a Record selection formula?  The Group selection formula will be processed in memory instead of by the database.

-Dell