I downloaded and installed Aspose.Cells for Reporting Services manually, ran my report and select export format "XLS - Excel Workbook via Aspose.Cells" clicked on export and received this error, "Reporting Services Error, For more information about this error navigate to the report server on the local server machine, or enable remote errors". This report works fine if I chose the default Excel export format.
This is the error message I received from the server, "An unexpected error occurred in Report Processing. (rsInternalError) An error occurred during rendering of the report. Object reference not set to an instance of an object."
Thanks for the fix. Now when I export a Reporting Services report to Aspose XLS format I do not receive any more error but I do have a couple of data formating issues:
1) date: my format in RS is: MMM-dd-yy, received Aug-13-07 when exported to MS Excel, received 2007-08-13 00:00:00 when exported to Aspose XLS.
2) number: my format in RS is: n2, received 2,500.00 when exported to MS Excel, received 2500 when exported to Aspose XLS.