Creating reports and dashboards | Stimulsoft community forum

Posted: **Tue Oct 16, 2012 8:56 am**

Hello,

We are currently with version 2012.1.1300.1 (2012/09/28 10:40) of Stimulsoft Reports.Ultimate and Windows 7 (64 bit) and have an issue with the generation and output of Excel reports.

The following call:

StiReportResponse.ResponseAsExcel2007

functions correctly with Firefox 15 & 16 and IE9. With IE7 and IE8 we get an error messages. The message box containing the error message can be seen here: http://imgur.com/JTpwi

The message box states that the the aspx page with the report can't be downloaded. However, it does exist as everything is working fine with Firefox 15 & 16 and IE9.

Have you an idea what could be causing the issue?

Kind regards

Posted: **Tue Oct 16, 2012 1:06 pm**

Hello.

There was an improvement in this direction. Please, try to use the latest prerelease build.

Thank you.

Posted: **Wed Oct 24, 2012 11:30 am**

Hello,

thank you for your answer. We have tested the prerelease SR_2012.10.12, but the problem still remains, no output in IE8.

Kind regards

Posted: **Thu Oct 25, 2012 12:28 pm**

Hello.

We couldn't reproduce the issue.
Please write us next information:
1. Does this problem occurs just with Excel export only or with other exports too?
2. Which operation system do you use? 32 or 64 bit?
3. Does this problem occurs on the IIS server or on the development machine?

If you use IIS, please, try to disable caching and data compression.

Thank you.

Posted: **Thu Nov 08, 2012 10:51 am**

Hi,
our problem occurs with excel and pdf, other formats are not in use.
Show report in StiWebViewer works fine.

We use Windows7 64 bit with IIS 7 and .net 4.0.
We have disabled caching and data compression.

Within our web application we start report output when a button is clicked. In JavaScript, an
event handler opens a page in a new window:

function onClickStartReport(..) {
:
window.open('<%= Page.ResolveUrl("~/AccessControl/Report/ReportPdfView.aspx?ReportType=' + reportType + '&ReportID=' + merker + '&asPDF=true' + '&millis=' + millis + '") %>',
'Test', 'width=400,height=200,resizable=yes');
:
}

The Page ReportPdfView.aspx is empty:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
</body>
</html>

In the CodeBehind ReportPdfView.aspx.cs is the following code that renders the report. It doesn't matter if the code is in
Page_Load() or OnPreRender(..):

var stimulReport = new StiReport();
stimulReport.Load(reportLayout);
stimulReport.RegData(reportData);
var spes = new StiPdfExportSettings();
spes.Compressed = false;
StiReportResponse.ResponseAsPdf(this, stimulReport, false, spes);

Method ..ResponseAsPdf(..) always throws a ThreadAbortException !
Nevertheless, report is displayed in IE9, but IE8 shows an empty window. There isn't any error message (e.g. java script) in IE8.

If we change the call of ResponseAsPdf() to StiReportResponse.ResponseAsPdf(this, stimulReport, true, spes), it still does not
work. But the behaviour is slightly different: the opened window is closed.

Opening the page ReportPdfView.aspx as link works for IE8 too:
function onClickStartReport(..) {
:
window.top.location.href = '<%= Page.ResolveUrl("~/AccessControl/Report/ReportPView.aspx?ReportType=' + reportType + '&ReportID=' + merker + '&asPDF=true' + '&millis=' + millis + '") %>';
:
}

But this is not what we want to do in our application.

Do you have any idea ?

Best regards

Martin

Posted: **Fri Nov 09, 2012 10:21 am**

Hello,

Please try to set the following properties:

Code: Select all

StiOptions.Web.ClearResponseHeaders = true;
StiReportResponse.ResponseCacheTimeout = 0;

Also, the problem can depend on the following options in Internet Explorer:

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Problem with generation and output of Excel reports

Problem with generation and output of Excel reports

Re: Problem with generation and output of Excel reports

Re: Problem with generation and output of Excel reports

Re: Problem with generation and output of Excel reports

Re: Problem with generation and output of Excel reports

Re: Problem with generation and output of Excel reports