We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cells for Reporting Services performing poorly

I am running the latest version plus a off cycle upgrade 1.5.1.2 (which fixed a page break issue) and the component performs badly when I am exporting to xlsx. The export that I am trying to do is less than 80000 rows and 13 column with various datatypes, none of which is larger that varchar(255); about half are smaller than that. What I observe is that when I start the export to xlsx the report server process memory consumption climbs up to about 1.1GB. For the environment where i develop i get the error listed below. However it does work on a server with more ram, but still the process consumes 1.1+GB. I am concerned about using your component during more demanding usage and the fact that my smaller environment cant run the component at all. I’ve attached the database and table of data and the .rdl file that is causing the issue. I dont see any technical specs in the documentation related to ram or the the like. If you could provide some on memory/cpu specs that would be helpful.

An error occurred while exporting the report.
error message Exception of type 'System.OutOfMemoryException' was thrown.
stack trace at Aspose.Cells.ReportingServices.ReportItem.x50ab3302f8769047.get_xe944988856b6cea9()

at Aspose.Cells.ReportingServices.ReportItem.x77f91d2130d08599.xe406325e56f74b46(Int32 x85475f13960674da, ReportElement x5c5b051700e59c67)

at Aspose.Cells.ReportingServices.ReportItem.x4baaeff2346b420f.xe406325e56f74b46(Int32 x85475f13960674da, ReportElement x5c5b051700e59c67)

at Aspose.Cells.ReportingServices.ReportItem.xbd8cd0af7299d656.x801353cd36f8e70e()

at Aspose.Cells.ReportingServices.ReportItem.x555897a1eb70677c.xe406325e56f74b46(Int32 x85475f13960674da, ReportElement x5c5b051700e59c67)

at Aspose.Cells.ReportingServices.ReportItem.x5d9a63140eb6b015.Render()

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

Hi,<?xml:namespace prefix = u1 />

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We have checked your report define file in our following test environment:

Windows Server 2003 SP2 x86 (Virtual Box) /CPU AMD7750 /Memory 1GB RAM /Virtual Memory 1536MB / Version : 1.5.1.9

The Results are : Time : 70s / Memory : 700MB+ / File format : XLSX / File size : 8MB+

Please try the attached latest version. Please copy Aspose.Cells.ReportingServices.DLL (version 1.5.1.9) into ${SQL Server 2008 Reporting Service Installation folder}\Reporting Services\ReportServer\bin\ folder.

Also, we are developing the new version in order to reduce memory usage.

Thank You & Best Regards,