Creating reports and dashboards | Stimulsoft community forum

Hi,

I have serveral reports that when shown using StiWebViewerFx just appear blank most of the time, when the web application is hosted on a remote web server. However if I run the web application locally and get data from the remote server the reports usually show correctly.

I assume that this is some kind of timeout issue?

I have tried setting timeout properties (as shown below) but the problem remains.

this.Server.ScriptTimeout = 600;
StiWebViewerFx1.ServerTimeout = new TimeSpan(0, 3, 0);
Stimulsoft.Report.WebFx.StiWebViewerFxOptions.Connection.ClientRequestTimeout = 180;
StiWebViewerFx1.Report = objReport;

The problem also occurs in the StiWebDesigner preview, which either shows a server timeout error or a blank report.

I was running verson 2012.1 ultimate, and I have also tried the latest pre release.

Can anyone please help? - I really need to find a solution to this issue quickly.

Hello,

Please specify how many pages (and the rows in the database) contain your report? Does it contain images? Does the correct work depend on the report size?

Thank you.

Thanks Vladimir.

In one example the report contain 612 pages from 16280 rows of data. Only the title band of the report contains an image (company logo) which we use on all reports. Yes smaller reports with about 150 pages work fine.

If I enable caching (ReportCacheMode = StiReportCacheMode.Auto and the viewer CacheMode = Stimulsoft.Report.WebFx.StiWebViewerFx.StiCacheMode.Page) then the report will show the first page, and the last 48 pages, but pages 2 - 564 are blank.

Hello,

Please tell us the time after which the viewer displays a blank page. Also, please try to set a ServerTimeout property on the aspx page:

cc1:StiWebViewerFx ID="StiWebViewerFx1" runat="server" ServerTimeout="00:30:00"

This property affects the time that the report is stored in the server cache.

Also, please try to upgrade to the latest prerelease build.

Thank you.

Hi,

I have tried adding the ServerTimeout as you suggested (and I was already setting ServerTimeout in code as shown in my original post), and I am already running the latest prerelease build.

The aspx page calls a web service to get the dataset for the report which takes about 70 seconds, then calls RegData for the report, and assigns the report to the StiWebViewerFx control. The viewer control then shows the loading report progress bar for about 6 seconds, and renders the first page and the last 48 pages, but all the pages in between are blank.

Can anyone please help with this?

Hello.

The Report Cache Mode property of the report isn't supported by WebViewerFx.

Also, this error can occur during long-term execution of the script on the server side (the building of large and complex report). Please try to increasing the timeout of the script on your IIS server.

Also try to set caching priority: This property was added to our last prerelease build.

Thank you.

Hi,

I have tried setting CacheItemPriority as you have suggested. Also the IIS script timeouts are set at 15 minutes, in code I set the timeouts to 5 minutes.

Attached is an example report that was produced by my ASPX page, the page first gets the dataset for the report which took 1 minute 50 seconds, then the dataset is assigned to the report:

Report.BusinessObjectsStore.Clear();
DataSet objDataSet = BLL.Context.Report.Report_GetReportData(objReportID, strResourceLocation, objQueryParams);
Report.RegData("MLS", objDataSet);
if (objReportDetail != null)
{
ReportVariableAdd(Report, "@Summary", objReportDetail.Report_Summary ?? String.Empty);
}
Report.Dictionary.Synchronize();

Then the report is assigned to the viewer:

this.Server.ScriptTimeout = 300;
StiWebViewerFx1.ServerTimeout = new TimeSpan(0, 5, 0);
StiWebViewerFx1.CacheMode = Stimulsoft.Report.WebFx.StiWebViewerFx.StiCacheMode.Page;
Stimulsoft.Report.WebFx.StiWebViewerFxOptions.Connection.ClientRequestTimeout = 300;
StiWebViewerFx1.Report = objReport;

The viewer displays the loding report progress bar for about 6 seconds and then renders the report, but still only the first page and about the last 50 pages, all the pages in between are blank. The total time for the whole process was less than 2 minutes, so I'm not sure the problem is being caused by a timeout?

The rendered report is atached saved as a PDF.

Here is the report attachment for my previous post...

Hello,

Please try to use this option:
Thank you.