How can I increase the performance of Loading Data in Crystal Report in asp.net?
It takes a long time to load data.
At first time of loading it takes time (because of query it takes time to fetch Records).
When the next or preview is clicked (page navigation...) also it takes the same time.
When the data can be loaded in the Report
When the report is opened in Firefox it is faster.
Sample Code
DataTable reportTable = GetSource();
if (reportPath != "" && reportTable != null)
{
reportDoc.Load(@reportPath);
reportDoc.SetDataSource(reportTable);
crv.ReportSource = reportDoc;
}
In the page load the function is called each time the Records are loaded.
If I use above code in
(!IspostBack)
the paging is not working in the report.
How can I avoid them loading each time?
Kindly give me the solution
:(