Blank report in StiWebViewerFx

MartinB · Post by **MartinB** » Wed Jun 27, 2012 9:25 am

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.

Post by **Vladimir** » Thu Jun 28, 2012 3:18 am

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.

MartinB · Post by **MartinB** » Thu Jun 28, 2012 5:25 am

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.

Post by **Vladimir** » Fri Jun 29, 2012 2:24 am

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.

MartinB · Post by **MartinB** » Fri Jun 29, 2012 4:19 pm

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.

MartinB · Post by **MartinB** » Tue Jul 03, 2012 8:04 am

Can anyone please help with this?

Post by **HighAley** » Thu Jul 05, 2012 7:09 am

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:

Code: Select all

<cc1:StiWebViewerFx ID="StiWebViewerFx1" runat="server" CacheItemPriority="Normal">

This property was added to our last prerelease build.

Thank you.

MartinB · Post by **MartinB** » Mon Jul 09, 2012 9:18 am

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.

MartinB · Post by **MartinB** » Mon Jul 09, 2012 9:22 am

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

Post by **Vladimir** » Wed Jul 11, 2012 8:08 am

Hello,

Please try to use this option:

Code: Select all

.....
objReport.ReportCacheMode = StiReportCacheMode.Off;
StiWebViewerFx1.Report = objReport;

Thank you.