My report contains more than 50k columns.

[jagdeep]

I have a report for the past 6 months.

The report contains more than 50k columns, and servicenow has a threshold limit for only 50000.

How can I get the complete result in an excel sheet ?

[Satyaki Bose1 · Accepted solution]

You can make the changes, but this is again a out of the box feature.

the reason why the limit is set, to prevent performance issues.

running a huge or long running report on a particular table might cause performance issues.

• you can browse to sys_properties.list
• open glide.excel.max_cells property.
• here you can set the values of the rows you want to export in the excel sheet.

this will only apply for reports or excel exports. not for pdf files.

hope this answers your question.

if your satisfied, please mark it helpful.

[catchdini]

Hi Satyaki,

We are using Dublin and I didn't find glide.excel.max_cells in sys_properties.list. In this case, shall I create a new one with the value of 50000 for excel?

FYI ... I typed sys_properties.list in the filter text.

Thanks in advance.