Error exporting to Excel using HTML5 Viewer in Active Reports 10

Posted by: sam852 on 14 September 2017, 7:16 pm EST

  • Posted 14 September 2017, 7:16 pm EST

    [activereports_archive]Hi,

    I am using Active reports 10 service pack 2 and the HTML 5 viewer.

    Reports run fine and on my development machine I can export to PDF, Word and Excel. However when running from the test server, PDF and Word still work fine, but not Excel and I get the message

    The webpage at http://server/projects/ActiveReports.ar10?Token=xxx&Command=Export&ExportType=Xls&SaveAsDialog=true&Generation=1 might be temporarily down or it may have moved permanently to a new web address.

    The Active reports files I have on my server are

    DocumentFormat.OpenXml.dll

    GrapeCity.ActiveReports.Chart.v10.dll

    GrapeCity.ActiveReports.Diagnostics.v10.dll

    GrapeCity.ActiveReports.Document.v10.dll

    GrapeCity.ActiveReports.Export.Document.v10.dll

    GrapeCity.ActiveReports.Export.Excel.v10.dll

    GrapeCity.ActiveReports.Export.Html.v10.dll

    GrapeCity.ActiveReports.Export.Image.Unsafe.v10.dll

    GrapeCity.ActiveReports.Export.Image.v10.dll

    GrapeCity.ActiveReports.Export.Pdf.v10.dll

    GrapeCity.ActiveReports.Export.Rdf.v10.dll

    GrapeCity.ActiveReports.Export.Word.v10.dll

    GrapeCity.ActiveReports.Export.Xaml.v10.dll

    GrapeCity.ActiveReports.Export.Xml.v10.dll

    GrapeCity.ActiveReports.Extensibility.v10.dll

    GrapeCity.ActiveReports.Interop.v10.dll

    gRapeCity.ActiveReports.Serializer.v10.dll

    GrapeCity.ActiveReports.v10.dll

    GrapeCity.ActiveReports.Web.v10.dll

    Please can you advise as to what the problem may be.

    Kind Regards

    Sam

    [/activereports_archive]

  • Posted 14 September 2017, 7:16 pm EST

    [activereports_archive]The error you’ve mentioned usually occurs when a few dlls are missing, but from the list you’ve sent, it appears that you have all the required dlls on the server. Another cause of this occur could be if the report is too large (large no. of rows and columns). How many rows and columns does your report have? Can you attach the report causing the issue along with the data it uses so I can check it.

    And what type of application is it (ASP.NET/MVC/Html)?

    Thanks[/activereports_archive]

  • Posted 28 November 2018, 7:40 pm EST

    I ran into this problem today and traced it to an assembly version compatibility problem with DocumentFormat.OpenXml.

    Assembly GrapeCity.ActiveReports.Export.Excel.v10 references assembly: DocumentFormat.OpenXml, Version=2.0.5022.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

    Another component in my application references assembly: DocumentFormat.OpenXml, Version=2.7.2.0, Culture=neutral, PublicKeyToken=8fb06cb64d019a17

    That component and the DocumentFormat.OpenXml it references are both NuGet packages.

    And because the PublicKeyToken differs between the two different versions of DocumentFormat.OpenXml, binding redirection cannot be used. This appears to be a hard incompatibility.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels