Rendering Excel report using RDL via Aspose.Cells for Reporting Services causes error

Aspose.Cells Product Family
1

Hi,

We are using Aspose.Cells for Reporting Services, V 1.9.0.49 with SITE OEM License.

The Microsoft Office Excel 2007+ has a limitation of 31 characters for the Spreadsheet Names. We have some of the report names that are longer than that. In almost all the cases the Spreadsheet name just gets truncated to the first 31 characters and we are good with that.

However, there is one report that throws error on a consistent basis. We are not able to create a separate RDL to demonstrate this issue to you as it works in most cases. The report that errors out, shows the Stack Trace of the error. The error is attached.

Can you please check.

Thanks,

Ragu...

2

Hi,


Thanks for the stack trace.

Well, I am afraid, unless we have your source RDL report define file, we might not be able to evaluate your issue properly. Please provide us your sample RDL file here so that we could look into your issue soon.

Thank you.
3

We do not deliver our tech artifacts. This error is not happening across the board. Most of the reports the spreadsheet name gets truncated to 31 characters without any error. And we are not able to reproduce the error through a static RDL that we normally deliver to demostrate Aspose Issues.

However there are 2 reports that are throwing this error.

We wanted to bring this to your attention to see whether you can find the issue by looking at the stack trace. Is there any other place where we can see the full error details, and communicate that to you guys? We need directions.

Thanks,

Ragu...

4

Hi,


We have analyzed your issue. We think you must have the same worksheets name when truncating the names to 31 chars, so Aspose.Cells for RS would throw such an exception. For example, your report has many pages, e.g page names might be like (for first and second sheet etc.) following:
worksheetnamexxxxxxxxxxxxxxxxx-1 ,worksheetnamexxxxxxxxxxxxxxxxx-2… and so on. Now, page names would be automatically truncated to 31 characters (the chars in red(bold) would be eliminated) when the report exports to Excel file, so MS Excel will generally have the same worksheet names i.e…, worksheetnamexxxxxxxxxxxxxxxxx. Please fix it in your report define files accordingly, so when the truncation is done, there should be no duplicate names.

Thanks for your understanding!
5
Hi,

raguraman.vayanakkan:



However, there is another report which requires us to have page breaks between each of the group. Meaning that the group is setup with Group Properties->Page Breaks->Between Each instance of the Group in the RDL is checked. The report outputs about 192 groups. This report is still failing. When we export this report in Microsoft Excel it does the Sheet1 to Sheet192 in Excel. When we use the Aspose Excel its failing.


.....




Please provide us your sample RDL file here to evaluate your issue on our end. We will log a ticket for it into our database, so that the issue (if found) could be figured out soon.


Thank you.

6

Here is a Static RDL and outputs that shows the error. This RDL kicks out the Groups without any expression into a new page / spreadsheet. The same doesn't work even if we specify an expression.

To Summarize it creates error when we kick out Groups into a page with or without expression and we need the both the scenarios fixed ASAP in Aspose Excel.

Thanks,

Ragu...

7

Hi,


Thanks for providing us the RDL and template Excel files.

I observed the issue in your error spreadsheet. The report is failing when rendering Groups into a page with / without expressions as you pointed out. We need to investigate your issue. I have logged a ticket with an id “SSRS-40132” for your issue. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.
8

Hi ,

We have found the issues and fixed them.

Please try the fixed version: Aspose.Cells for Reporting Services (SSRS2008R2) V1.9.0.52.

Please copy Aspose.Cells.ReportingServices.dll into following folder:

${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know run result.

9

Shakeel,

We have tested this version and the issue is fixed. We will continue our testing with all the reports and if there are any issues we will let you know.

Thanks for the fix.

Thanks,

Ragu...

10

Hi,


Thanks for your feedback.

Good to know that your issue is resolved by the new fix. We have closed your ticket now.

Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thanks.
11

Shakeel,

We need to Re-Open the issue.

We have a situation where we use the expression to get the render format type and check to see whether its excel (Aspose XLSX) and if so we disable the grouping page break.

Meaning report has a parameter called PageBreak, when Yes, all report format types such as HTML, PDF break into new page for every group, except for Excel and Excel Data Only formats.

The simple expressions with report parameter seems to be working. But not the complex ones.

The same expression is working in MS Excel and it produces the output on a single spreadsheet for the same expression. Please note that the excel below is Aspose Excel as we posted the Renderer configuration.

=IIF(Globals!RenderFormat.Name="Excel" or Globals!RenderFormat.Name="EXCEL" or Globals!RenderFormat.Name="MS-EXCEL", TRUE, IIF(Parameters!PageBreak.Value="No", TRUE, FALSE))

The Static RDL to reproduce this scenario with the outputs created are attached with this thread.

This is a high priority item and we need your immediate attention.

Thanks,

Ragu...

12

Hi,


Thanks for the sample files.

I observed the differences as you pointed out. I have reopened your issue “SSRS-40132”. Our concerned developer will investigate and look into your requirements and we will get back to you soon.

Thanks,
13

Hi,

We have found the issues and fixed.

Please try the fixed version : Aspose.Cells for Reporting Services (SSRS2008R2) V1.9.0.53.

Please copy Aspose.Cells.ReportingServices.dll into following folder : ${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know your run result.

14

Amjad,

We tested this version and the reported issue is working fine. We can close this thread for this issue.

Thanks for your immediate attention within like 4 Hrs... We appreciate it.

Thanks,


Ragu...

15

Hi,

Thanks for your feedback and using Aspose.Cells for Reporting Services.

It is good to know that your issue is fixed with this latest version. We have closed this thread now. If you encounter any other issue, please feel free to post on our forum. We will be glad to help you further.

16

The issues you have found earlier (filed as SSRS-40132) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.