The response time of the KPI is very high and when I try using some features like Hide/Show Columns, Scrolling, it displays an IE script error. How can I fix it?
Check the value specified for the 'Max_row_count' property in arc.properties (For example, if the query returns records to the tune of 1000, and set as 5000, loading of records in the grid will make IE unresponsive, providing the script error). Modify the 'max_row_count' property to something lesser say 500 in arc.properties(Path: Tomcat\webapps\config), so that the grid loads only up to 500 records. When the limit exceeds this threshold value, the resultant output will be available for download through the link as an Excel/PDF report.