Making Crystal Reports Faster

[flepkows]

I have a crystal report which I am displaying using a web form viewer within an asp.net application. My report is based on a sort of recursive database design so my report is using aliases of many tables. I am wondering how to speed up this report, I looked into caching but that really doesn't solve my problem since my users will always want a freshly built report from the server. Anyone know about any special settings as far as where sorting is done client or server and so on to make this report run faster? Thanks in advance.

 

[Turkbear]

Hi,
Its not the settings but the actual query being executed that will determine the speed of response( in most cases).
Since you did not indicate the database used, these are a few generic ideas:

Analyze the query being sent to the database ( use the Show Sql Query option,under the database menu).

Be sure most of your selection criteria are being included in the where clauses, else too much data will be returned to the report server and 'handled' there..this is much less effficient than screening it at the database level.

Also be sure that indexes being used whenever possible.

If possible, create views in the database that handle the joins needed.

With more info ( Database used, version of CR, etc) perhaps more help can be provided.

 

[flepkows]

Thanks for your help. I am using MS Access for my database and CR for .net 2002. I am unable to view my sql query in the database tab, is this because I am reporting off of ADO.net dataset? Thanks in advance.

 

[rhinok]

Listen to turkbear Chances are your record selection statement isn't very efficient. Please paste your statement here and we'll review it for you. Also, please indicate your version of Crystal, the DB and the method for accessing the DB (ODBC, Native, ADO, etc...)


~Kurt