Slow save as csv - need help!

Are you running this as a stand-alone or is the database on a separate server?

You might look at the option settings, under tools on the RS screen and tweak the buffers and/or process on the server if possible.

Look at the how the report is structured and use the group by sorting on the server.

Macros are faster. I have used them for various applications. I personally would output the data to a flat file and then pull it into EXCEL if I needed.

You can also use scheduler to run off hours.

Just some thoughts.



David L. Black Consulting

Thanks for the reply. ReportSmith is stand-alone accessing an Oracle database on a server in native mode.

I am using only 1 table, 1 derived field (constant--no functions or formulas). When you say sort on the server, you mean use the group by? I am sorting by 5 fields using the Sort criteria tab.

The table I am hitting is close to 700,000 records, of which I am selecting 10-30K rows (because of the 32K record limit). Is my PC going through all 700,000 records? The report itself loads in a few seconds on my screen.

jdiguy

Yes, I meant the group by, try to reduce the number of records that RS has to process.

Your ADP RS support group should be able to provide you with a sample macro that will produce a fixed length flat file.

I also recall an issue with the max. number of rows that EXCEL can handle. This is a Microsoft restriction not RS.

You may also want to try for known issues.



David L. Black Consulting