Why is Crystal Reports Query so slow?

Question

I have many Crystal Reports to the same database. Some execute quickly given the same date parameters and many fields are the same as well as the tables they access. One of my reports used to run quickly is now running very slow and I can see it looking through all the records - represented in the bottom 0 of 100000 til it finds records. I have no idea what I may have changed to make it do this. Some reports still run fast and some do not. These findings are consistent with the reports I am talking about. Does anyone know why setting might be causing this?

I have tried looking for any subtle differences in them - I cannot see anything. Many of them where clones from the original(still works fast).

In my CR book in the performance section it states if the where clause can not be translated it will be ignored and for the process of all records - which is what this looks like - though I have a valid where clause when I check it in the report.

Use Indexes Or Server For Speed is checked. All other setting in Report Options as identical.

Thanks

Answer 1

You can do some troubleshoot:

• Try run your query directly on db and see how long it takes.

• Is there any business logic added in your report.

• May be also try to put same query in fresh report and see if it takes similar time.
• Also try debug your application and see if some part of your code making your report to show slow.
• Are you running it on local db or on some server.
• Also if you can share your query, so I can take a look.

Let me know if you need more help.