Problem exporting large amount of data

[Former Member]

Hi all,

I've created a web application with Visual Studio 2005 and Crystal Report for visual Studio 2005 (using VB). I have a problem when I try to export more than 220000 rows to excel (data only) format. I've seen that application creates a cpe{}.tmp file in WINDOWS\Temp directory and to do that it takes about 10 minutes. If I try to do export before cpe{}.tmp file is completely generated I received an error on my pop up page ("Internet Explorer cannot display the webpage"). How can I solve It? How can I check if file is completely generated?

Thanks!

[former_member183750 · Accepted solution]

The 1st thing to go after is the latest Service Pack:

https://smpdl.sap-ag.de/~sapidp/012002523100009351512008E/crbasic2008sp1.exe

Next, test the export to other formats. I'd recommend CR file format and PDF. Does that work? E.g.; is this isolated to export to XLS?

- Ludek

[Former Member · Accepted solution]

Ok, I've installed SP1 but nothing changes. I try to export to .rpt and to .pdf format. The first format work well but export to .pdf fails. However I need to export to excel data only.

Others suggestions?

Thanks!

[former_member183750 · Accepted solution]

Define:

"...export to .pdf fails..."

Errors? Behavior? Symptom?

- Ludek

[Former Member · Accepted solution]

The same error again, "Internet Explorer cannot display the webpage".

[former_member183750 · Accepted solution]

Are you exporting using the viewer export button or code? If code, can you pate it in here?

Also, try a simple win app - one line should be all you need;

CrystalreportViewer1.ReportSource = <path to report>

- Ludek

[Former Member · Accepted solution]

I'm exporting using the viewer export button. I've created a Crystal Report Source that i've assigned to my Crystal report Viewer.

[former_member183750 · Accepted solution]

So, what does a Win app do?

- Ludek