Exporting Reports to Excel capped at 10000

[jmiskey]

Using Helsinki, we have a report that has about 14,500 records in it.

I run it, and then right-click up in the header and elect to export to Excel (it asks me if I want it emailed to me, and I say yes).   However, when it comes to me, it only shows 10,000.   In I export to CSV, it returns all 14,500 rows.

I found this article here: Increasing the Export Limit

So, I looked up our settings, and this is what they look like:

So it looks like it should be able to easily handle 14,500 records.

I thought maybe that it didn't like the "Type" setting of "string", so I tried changing it to "integer" and tried again.   But that made no difference.   The report emailed to me was still capped at 10,000 records.

What am I doing wrong?

[Arnoud Kooi]

Did you try loging out / in and open /cache.do?

[jmiskey]

No, unfortunately that did not work.   Still returning 10000 records.

I have tried both ways, but can you confirm for me what that "Type" field should be set to?   String or integer?

Any other ideas?

[Arnoud Kooi · Accepted solution]

For XLSX format there is an new property

Did you add the property glide.xlsx.export.limit ? Add it as a integer, as that is what it is..

[jmiskey]

That worked!   I guess they need to update their documentation!

Thanks!