Is there a row limit within a report using a pivot table?

[DianeG]

It's been requested to create a report with the amount of hrs spent per demand by a certain team for the yr. We are using the time card table with pivot table. I have tried to find if there is a row limit within sys_properties, I can find a sys_property for report list view but that is as far as I can find. 

[SK Chand Basha]

Hi @DianeG 

I think unfortunately there is no property to increase more than 5 rows.

https://www.servicenow.com/docs/bundle/xanadu-now-intelligence/page/use/reporting/concept/c_Multilev...

Mark it helpful and Accept Solution!! If this helps you to understand. 

[mia45]

You might not find a row limit specifically for pivot tables in sys_properties. However, check the glide.ui.list_v2_max_row_limit property, which controls the number of rows displayed in lists and could be affecting the pivot table. If it's not the issue, try adjusting the pivot table settings or using an export method to handle large data. If you're looking to baixar Spotify Premium, make sure to avoid unofficial sources that could compromise your device's security. You could also pre-aggregate the data using a Scheduled Script or Business Rule to avoid hitting limits and optimize the report generation.

[mia45]

In ServiceNow, there's no specific sys_property for limiting rows in a pivot table, but you can adjust the Row Limit in the Pivot Table Settings. Increase the row limit or set it to "0" for unlimited rows. Check for other performance-related properties in sys_properties like com.glide.report.limit or com.glide.report.max_rows. If performance is a concern, try narrowing the report's scope by applying additional filters. For instance, if you're looking for a same day MOT Peterborough and need a quick turnaround, limiting the data scope might help you get results faster without performance issues.