[RESOLVED] Crystal reports - huge report, how to speed it up?

Hi,

I have a problem with crystal reports. I've created one single report which should show me everything from certain ms access tables(two tables). In my sql query there is two date(string) confinings. In this table where I want my data out is over 500 000 rows. I've optimized my query and it should be as fast as it can be. But anyway my problem is that the report is so darn slow. It takes over 45 minutes to show up.

Like I said that the query is as fast it can be, I've performed it in ms access and this query works fine (and fast). So the problem isn't in my query, I think crystal reports is braking my report.

What can I do to speed it up?

Do you have any conditional or selection formulas in your report? When you run it through Access how long does it take. How about any subreports, etc? How are you connecting to your db in CR?

Quote:

---

Originally Posted by Arto

Hi,

I have a problem with crystal reports. I've created one single report which should show me everything from certain ms access tables(two tables). In my sql query there is two date(string) confinings. In this table where I want my data out is over 500 000 rows. I've optimized my query and it should be as fast as it can be. But anyway my problem is that the report is so darn slow. It takes over 45 minutes to show up.

Like I said that the query is as fast it can be, I've performed it in ms access and this query works fine (and fast). So the problem isn't in my query, I think crystal reports is braking my report.

What can I do to speed it up?

---

Saving data in the report has a big effect to the speed of the report. Try to see if the "Save Data with Report" option is selected. If yes, that may be the cause.

Quote:

---

Originally Posted by RobDog888

Do you have any conditional or selection formulas in your report? When you run it through Access how long does it take. How about any subreports, etc? How are you connecting to your db in CR?

---

There's no formulas in my report at all(well, I use CRs sum function once at report footer). When I run it through access it takes only few seconds, so I think there's nothing wrong in my query. And no, there's no subreports. Only one group. CR is connected to database via ODBC. Any suggestions?

Quote:

---

Originally Posted by oreo

Saving data in the report has a big effect to the speed of the report. Try to see if the "Save Data with Report" option is selected. If yes, that may be the cause.

---

Where can I see this option? When I run my report it few seconds stress my cpu 100% and then it starts to swap. It's creating this huge temp file to my hard-drive.

File > Report Options > uncheck "Save data with report.". ;)

Oh, I see :)

And it works! Now this report shows up after 1-2 minutes. Great, thanks.

I don't have a solution to Arto's query but saving data with report will cause the report to return the old data. It will not reflect the updated status of the data. This scenario is advisable for static data.

Has anyone ever had a situation where Save Data With Report is used or even necessary?

Quote:

---

Originally Posted by RobDog888

Has anyone ever had a situation where Save Data With Report is used or even necessary?

---

I think it is useful when you need to export(.pdf, doc..) your report fast. If you have "save data with report" unchecked exporting takes longer time, but if it's checked you can export you report in notime.

True, but with static old data dont seem valid if you need updates. ;)