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
Problem with generation and output of Excel reports
Re: Problem with generation and output of Excel reports
Hello.
There was an improvement in this direction. Please, try to use the latest prerelease build.
Thank you.
There was an improvement in this direction. Please, try to use the latest prerelease build.
Thank you.
Re: Problem with generation and output of Excel reports
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
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
Re: Problem with generation and output of Excel reports
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.
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.
-
martinxmueller
- Posts: 8
- Joined: Fri Oct 26, 2012 10:12 am
Re: Problem with generation and output of Excel reports
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
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
Re: Problem with generation and output of Excel reports
Hello,
Please try to set the following properties:
Also, the problem can depend on the following options in Internet Explorer:
Thank you.
Please try to set the following properties:
Code: Select all
StiOptions.Web.ClearResponseHeaders = true;
StiReportResponse.ResponseCacheTimeout = 0;Thank you.