Error export to Aspose XLS from a Reporting Service report

Hi,

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.

Please advise,

Thanks,

Hi,

Please post the rdl file here. You can get the error message when exporting the report on server machine, please post the message here.

Thanks

Hi Nick,

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."

Rdl file is attached.

Thanks,

Hi,

I've found the reason, it takes several days to solve it.

Thanks

Hi,

I've fixed the bug. Please try v1.0.1.2 in attachment.

Thanks

Hi,

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.

Thanks,

hi,

do you edit this rdl file? Please post the lastest rdl file here.

Thanks.

Hi,

Attched is the rdl file requested.

Thanks,

Hi,

Thanks for the file, We will check and get back to you soon.

Thank you.

Hi,

I've fixed the bug. Please try v1.0.1.3 in attachment.

Thanks