Performance Issue with Crystal Reports and ASP.Net
-
Hello, We urgently need help on performance issue in Crystal Reports. We are able to view the report using Crystal Report IDE. But the same report is timing out when tried to display it using Crystal Report viewer from a ASP.Net application (back end language used C#). The crystal report is getting populated based on a stored procedure and is mapped in the report (pull model). We are using Crystal Report Version XI. The report is taking around 5 minutes in the Crystal Report IDE, and corresponding stored procedure is taking around 1.5 minutes for retrieving 300+ records. For the same scenario, the report is getting timed out from the application. The report takes dates (start and end date) as input parameters and for a lesser precision (for 1 year the report is getting generated). The report has formulas for calculating the sub-totals and a grand totals of some amount field value. The backend table has more than 1 million records and it will not be possible to archive some data as it is a requirement. The data in table will grow periodically. Please let us know if you have faced any similar issue any time. Also, any suggestions in designing the report which can display the data running in lakhs of records. Thanks in advance. Regards Vamsi Mohan Harish
-
Hello, We urgently need help on performance issue in Crystal Reports. We are able to view the report using Crystal Report IDE. But the same report is timing out when tried to display it using Crystal Report viewer from a ASP.Net application (back end language used C#). The crystal report is getting populated based on a stored procedure and is mapped in the report (pull model). We are using Crystal Report Version XI. The report is taking around 5 minutes in the Crystal Report IDE, and corresponding stored procedure is taking around 1.5 minutes for retrieving 300+ records. For the same scenario, the report is getting timed out from the application. The report takes dates (start and end date) as input parameters and for a lesser precision (for 1 year the report is getting generated). The report has formulas for calculating the sub-totals and a grand totals of some amount field value. The backend table has more than 1 million records and it will not be possible to archive some data as it is a requirement. The data in table will grow periodically. Please let us know if you have faced any similar issue any time. Also, any suggestions in designing the report which can display the data running in lakhs of records. Thanks in advance. Regards Vamsi Mohan Harish
u have to set the timeout property of ur connection info for ur connection info object like this... Dim attrib As DbConnectionAttributes attrib = connInfo.Attributes attrib.Collection.Add(New NameValuePair2("Connection Timeout", "50"))
VMSSanthosh