Crystal Report from CSV file is EXTREMELY SLOW

[vjmaggi]

I have Crystal Reports 2008 and have a report built from two very small csv files. These files are 3 & 4 kb in size. One file is only used to retrieve a single piece of data for the header of the report, the other is used for all other data on the report. The report is a single page report with a chart. Crystal Reports is on my computer, as are the two csv files. For some reason, verifying database takes a full 12 minutes and a report refresh takes at times a full 5 minutes. Any ideas on what the issue could be that is causing such slow responses?

 

[MJRBIM]

How do you have the two tables linked...?

What happens if you create a report against just one of the tables...? Does performance improve...?

Senior Business Intelligence Consultant
Toronto, Canada

SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services

 

[SchwabTerex]

You've probably solved this by now. However, I had to do some searching lately to fix a report I had created with a csv file. I've never created a report in Crystal from a csv file before and I found out the reason my report was so terribly slow (9 min) was that I had used the wrong kind of connection when I began the report. I found a user that said to use the access/excel connection for a csv file. With that fixed my report runs in less than a minute. Just thouhgt I'd pass the info on in case it could help.