data Exporting Issue

[svsudhakar]

Hi ,

I have created one straight table report. It's having 30 fields. While exporting that report in to Excel I am getting Out of Memory Exception.

That report having nearly 3lacs records. Please suggest.

Below are the error screen shot. Please find it

Thanks in Advance..

[#2]

RAM issue.. Try applying some filter and your export should work..

[svsudhakar]

Thanks Danial for your reply.

Actual scenario is user wants it in single Excel file and more over don't want any filters also.

Please suggest is there any other solution for this.

[#4]

If you're working on a VM you could try allocating more RAM.

Also see if you can delete fields, perform computations in the backend, replace if statements with set analysis.

Just for testing purposes I suggest trying to make a smaller export first, see if that works (ie. only 2013 if you've data for several years).

[#5]

Hi ,

You can export that staright table like select that table--propersties--export-save as in (qvd) then open that qvd.

then store that data into your required format whether excel or csv or txt.Its better to store in txt format for large no. of records.

To store use below:

store t1 into path\file.txt(txt, delimiter is '|' );

Rgds,

Harshal Patil

[Clever_Anjos]

If is possible, preagregate all your expressions and use a Table Box instead of Straight Table.

Table box is much less RAM intensive