Exporting 30k records in PDF using glide.pdf.max_rows

andypollino
Mega Expert

Hi. I'd like to export a report containing a lot of rows. An answer to Increase Excel Export Limit?   directed me to https://wiki.servicenow.com/index.php?title=Exporting_Data#Export_Limits , which was pretty helpful. As I understood section 8.1, setting glide.pdf.max_rows in sys_properties would allow me to export more than 5000 rows. I did that, but my large report still exports only 5000 rows. I confirmed in System Properties > Import Export that my value is larger:

find_real_file.png

Yet, when I export, I get 5000 rows. The PDF does have this info in it, however:

find_real_file.png

This leads me to believe that glide.pdf.max_rows can only further restrict users, not enable them. If I consult https://wiki.servicenow.com/index.php?title=Exporting_Data#Breaking_Up_Large_Exports&gsc.tab=0 , I see tips for breaking up large exports as a list view. I don't quite know how to apply this to reports, however. In my exact case, I could run a bunch of quarterly reports instead of one long report, but I'm wondering if there's a more user friendly way to do this.

1 ACCEPTED SOLUTION

Jaspal Singh
Mega Patron
Mega Patron
2 REPLIES 2

Jaspal Singh
Mega Patron
Mega Patron

Hi Andy,



You may find   link PDF glide.pdf.max_rows is not working   helpful.


Thank you for that link, I hadn't seen it before. That is quite frustrating, but I guess we will have to work around it.