How to improve report render

[hanntd]

Dear,
I'm facing the issue with report render, it's very slow when report load large record and pages (the query I run in SQL Server just take several seconds). I debuged it is slow when call Render() method. My code:
//Init data report

report.ReportCacheMode = StiReportCacheMode.On;
report.ReportCachePath = Directory.GetParent(HttpContext.Current.Server.MapPath("")) + "\\Reports\\";
report.Load(Directory.GetParent(HttpContext.Current.Server.MapPath("")) + "\\Reports\\" + rptRunning.ReportName + ".mrt");
report.Dictionary.Databases.Clear();
report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiOleDbDatabase("Data", "Provider=SQLNCLI10.1;" + entityBuilder.ProviderConnectionString));

for (int i = 0; i < report.Dictionary.DataSources.Count; i++)
{
((StiSqlSource)report.Dictionary.DataSources).CommandTimeout = 600;
}
report.Compile();
report["_RPTID"] = Convert.ToDouble(rptRunning.ReportID);
report.Render(false);
So how I can fix and improve the report performance.
Thanks
Han

[HighAley]

Hello.

How many pages and records are there in your report?

Thank you.

[hanntd]

I'm testing the data with 100,000+ rows and 1,000 + pages.
Thanks
Han

[HighAley]

Hello.

I'm testing the data with 100,000+ rows and 1,000 + pages.

It's a very much amount of data for SIlverlight. It will work so slow.
If you want to improve your report performance you should split your report on several with less data.

Thank you.

[hanntd]

Do we have any method to show report on demand, I mean just show the first page at beginning and everytime user click Next page we will show the next page only.
How is the maximum capability of Stimulsoft Silverlight report?
Thanks
Han

[HighAley]

Hello.

Do we have any method to show report on demand, I mean just show the first page at beginning and everytime user click Next page we will show the next page only.
How is the maximum capability of Stimulsoft Silverlight report?

Unfortunately, the report should be rendered before showing to know how many pages are in it.
The maximum amount of pages depends on content. Is there any images or rich-text components.
There is a Stop Before Page property of report to set maximum rendered pages. But other pages will not be rendered at all.

Thank you.