how to extend limit of exporting record from 1000 to 30000 in a report?

manmathpanda · ‎06-03-2019

Hi Developers,

There are almost 26000 records in a report and i want to fetch all the record once. but while pressing on SAVE button and clicking on export to excel, it only dowonloads 1000 records. But i want to download all the records i.e 27000 into excel.

for this i went to system configuration--- import/export----- in excel i made it 300000

still it is only downloading 1000 records.

Please suggest ?

Regards,

Manmath

Sanjay Bagri1 · ‎06-04-2019

If you want to export as a pdf so it is not possible I have tried in this way .

But different way is export as a csv this much file or xlsx and convert to converter as a PDF , I have this is tested and converted .

Converter link : click here to convert CSV to PDF file

This is I have converted and downloaded.

Please mark as correct and also helpful so other will be benefitted for same threads .

Thanks

Sanjay Bagri

View solution in original post

Ankur Bawiskar · ‎06-03-2019

Hi Manmath,

So even though you set the property to max value it is not working?

Regards

Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

manmathpanda · ‎06-03-2019

yes , it is not working.

i have maximized the limit to 30000, but when i will click on save button of report , it is only downloading 1000 records only.

Regards,

Manmath

Deepak Ingale1 · ‎06-03-2019

Try to hit cache.do page, relogin to instance and see if it works.

Sanjay Bagri1 · ‎06-03-2019

Hi ,

I also faced same issue earlier , if you have change the property but still you are not able to export .Let me know you have change the Xlsx/xls . if xlsx then ok ,