An error occurred while exporting the report in XLSX

Aspose.Cells Product Family
1

Hi,

We have an issue when exporting a SSRS report in ASPOSE XLSX 2007.

Indeed, when we open the Excel file, the following error is present whereas the report is well displayed in the web browser or BIDS:

(processing): Invalid offset for item. ReferenceID: ffffffffffffff37, Offset: -201
at –.Œ.(ReportItem item, Int32 colspan, Int32 columnIndex, Int32 Left, Int32 Top)
at –.Œ.(TablixMember tm,  row, Int32 left, Int32 top, Boolean& flag)
at –.Œ.(TablixMember tm,  row, Int32 left, Int32 top, Boolean& flag)
at –.Œ.(TablixMember tm,  row, Int32 left, Int32 top, Boolean& flag)
at –.Œ.(TablixMember tm,  row, Int32 left, Int32 top, Boolean& flag)
at –.Œ.(TablixMember tm,  row, Int32 left, Int32 top, Boolean& flag)
at –.Œ.(TablixMember tm,  row, Int32 left, Int32 top, Boolean& flag)
at –.Œ.(TablixMember tm,  row, Int32 left, Int32 top, Boolean& flag)
at –.Œ.(TablixMember tm,  row, Int32 left, Int32 top, Boolean& flag)
at –.Œ.( row, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.( tm, Int32 left, Int32 top)
at –.Œ.()
at –.Œ.a()
at •.•.(ReportItemCollection reportItems)
at –..a()


Moreover, we have a tablix control within another tablix and when, with another parameters, we can export the report, a merge column exist as shown in the file attachment. This merge is not allowed because of my customer’s needs.

Thanks in advance for your help.

Version product :1.9.0.0 &1.9.0.23
Product name : Aspose.Cells.ReportingServices
For information, it’s based on a purchased product (GDF Suez - France)
GDF SUEZ DSI CSPI CGLL
Licence type : Site Small Business

2

Hi,

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

Please try the latest version: Aspose.Cells
for Reporting Services v1.8.0.78 (MSI)

And let us know your feedback.

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

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

If the problem still occurs, please provide us your RDL file and the xlsx rendering.

3

We already have the 1.9.XX version : why should we use a old version?

Please find the RDL File

4

Hi,

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

We have logged your issue in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as SSRS-40105.

5

Hi,

We have tested your provided report define file. It is OK.

Please try the latest attached version : Aspose.Cells for Reporting Services (SSRS2008) V1.9.0.25.

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

Please let us know run result.

Thank you.

6

Hello,

We have reproduced the steps with the new dll, but infortunately, the issue keeps occuring.
The rdl file seems to be ok, and the xls export works properly.

The report on which the issue occurs is really critical so do not hesitate to contact me to get more information.

Thanks.

7

Hi,

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

We have logged your comments inside our database. We will look into your issue and provide you a fix asap. Please also provide us your xls export.

8

Hello,

Thanks for your reply.
You will find the xlsx export attached.
Nevermind the empty columns, i erased business related data. I also highlighted columns ‘M’ and ‘GW’. The ‘M’ column is the one causing the problem in the first place, but i noticed that the creation of the ‘M’ column actually pushes the child tablix further on the right.

I hope you’ll understand the problem and come up with a solution for this.
Let me know if I can help.

Thanks.

9

Hi,

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

We have logged your comments in our database. We will look into it and once there is some update for you, we will let you know asap.

10

Hi,

We found a workaround to solve the problem. The error was coming from header columns that weren’t formatted properly. The issue didn’t even occur when exporting to xls, so it might be interesting for you to look for a fix.

Do not hesitate to get back at me should you need additional information regarding the issue.

Thanks.

11

Hi,

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

It is good to know you got some workaround. We will look into your issue and if we need any information at your end, we will ask you. We have also logged your comments in our database.

12

Hi,

We have found the issues and fixed them.

Please try the fixed version: Aspose.Cells for Reporting Services (SSRS2008).

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

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

Please let us know run result.

13

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

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