We are getting the error below when we try to use the export to any Aspose type. It works to csv but the native excel doesn't allow us to go past the 65k row limit.
An error occurred while exporting the report. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
error message
Could not load type 'Microsoft.ReportingServices.OnDemandReportRendering.Map' from assembly 'Microsoft.ReportingServices.ProcessingCore, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.
stack trace
at Aspose.Cells.ReportingServices.ReportItem.xbd8cd0af7299d656.xb068ca8b20b829ba(ReportItem xe4de920c4d28a5eb) at Aspose.Cells.ReportingServices.ReportItem.xbd8cd0af7299d656.x78831a46799eb787(ReportItemCollection x5ae199cc021ab18c) at Aspose.Cells.ReportingServices.ReportItem.x555897a1eb70677c.GetFormatDefine() at Aspose.Cells.ReportingServices.ReportItem.x5d9a63140eb6b015.GetReportDefine() at Aspose.Cells.ReportingServices.Renderer.x287918d12b9d430a(Report x64343a0786fb9a3f, NameValueCollection x4d7e972a483f38e6, NameValueCollection x769338e163ee6eb4, NameValueCollection x69ea43ef171861cd, Hashtable& xcc726f61cfb91835, CreateAndRegisterStream x6af66da7eca40f82) at Aspose.Cells.ReportingServices.Renderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
1) The .CSV format does support more than 65k rows limit. 2) Map report item is provided by SSRS2008 R2. If you use Aspose.Cells for Reporting Services 2008 R2 version to deploy on SQL Server 2008 Reporting Services, the error will be occurred. Please tell us how you deploy Aspose.Cells for Reporting Services and which version of Aspose.Cells.ReportingServices.dll version you are using?
Please try copying Aspose.Cells.ReportingServices.dll which is be ${installation folder} \Bin\SSRS2008R2\ folder into the following folder: ${ SQLSERVER2008R2 installation folder} \Reporting Services\ReportServer\bin.