How to chunk huge csv report that is exported as csv into like 50 Mb

[shib_best]

How to chunk huge csv report that is exported as csv into like 50 Mb.

I have a report which export a csv size of 900 mb ,I need to slipt it in multiple csv files while exporting.

 

 

[peter.w]

Hi

Not sure if this will work but have you tried making the export report query use a limit?

EG:

if you know how many records you are going to export

SELECT COUNT(TRANSACTION_ID_NO) AS tran_count
FROM transaction

tran_count = 1000

In the actual export report take two parameters START_AT and LIMIT_TOO so that

SELECT *
FROM  transaction
LIMIT 0 , 500
This gives the first 500 rows becomes something like this in jasper

SELECT *
FROM  transaction
LIMIT $P{START_AT} , $P{LIMIT_TOO}

You would have to call the report more than once with the start and row count each time.