We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date



How can I preformance tune the Windows server to make reports work faster.

We are running a Win 2012 server in Amazon Web Services and adding either CPU or memory does not seem to make a report run faster.

I would like some advice on how to performance tune the server/software to get the report to refresh quicker.

The SQL query returns on the DB in less than 2 seconds but the report takes 45+ seceonds to return.



1 Reply

VS Vinoth Srinivasan Syncfusion Team June 6, 2017 01:41 PM UTC

Hi Patrick, 
You can improve the performance of report rendering with following report item level changes. 
1.     If you are using Tablix report item and the CanGrow property given as true, then set CanGrow property as false for all textboxes which has static text also possible items which will not exceed design height.  
2.     As said above point you can set CanGrow property as false for Tablix header rows and any static cells.  
3.     Remove unused datasources and datasets in a report.  
Vinoth S. 

Live Chat Icon For mobile
Up arrow icon