Rendering MS Excel reports (XLSX) via SSRS issue

Aspose.Cells Product Family
21

Hi,

Thanks for using Aspose.Cells for Reporting Services.

We have tested your provided report definition file and could not find any issue.

Please try the latest version 2.1.0.9 (attached)

If you still face the issues, please post some information here.

1. Report Parameter running values .

2. MS default exported excel file.

22
Hello MShakeel,

Have attached the parameter value and I am unable to understand what you mean by MS default exported file ? We have attached the export which we get after exporting if it suits your requirements.



Regards
Kanwar
23

Hi Kanwar,

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

We actually need XLS export which is built-in and done by SSRS engine. It means, the XLS export by SSRS report engine.

24

Hi,

We have evaluated your issue further. We could not reproduce it, so we update some exception handling.

Please try the new version/fix : Aspose.Cells for Reporting Services (SSRS2008R2) V21.0.11 (attached).

Please let us know your run result.

Thank you.

25

Hi,

Please try our latest version/fix: Aspose.Cells for Reporting Services V2.1.0.16 (attached).

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

Please let us know run result.

If you still face the issues, please post your report file here.

We will check it ASAP.

26
Hello Amjad,

We have bought the license of Aspose and we are using Aspose for SSRS 2005 and 2008.

I have attached the RDL for reference. We are running this RDL with three different scenarios ( for different value of HisOption parameter) . Previously two scenarios were not opening (when setting HisOption as 1 and 2) and giving error. Now they are opening but they are giving below errors :-

1) The header seems to be missing when setting HisOption as 2( attached HeaderMissing.xlsx for reference) .

2) You might be aware that if we pass rs:Format = "ACXLSX" as parameter in Go to a report then normally Report will be opened as Excel file(on header Click, have attached normal.xlsx for Reference). Rest all files are working as expected but after your rectification the scenario where we set HisOption as 2 then cell click is ignoring the rs:Format parameter and opening the hyperlink in a browser instead of Excel (have attached HyperLink.xlsx for reference).

Kindly look into the issues ASAP.

Regards
Kanwar
27

Hi,


Thanks for providing us sample RDL and output Excel files.

I have logged the following issues into our database, we will investigate your issues in details and figure them out soon:
SSRS-40200 - The header seems to be missing when setting HisOption as 2
SSRS-40201 - After setting HisOption as 2 then clicking the cell ignores the rs:Format parameter when opening the hyperlink into the browser

Once we have any update on any of the above mentioned issues, we will let you know here.

Thank you.


28

Hi,

We have found the issue and fixed it.

Fixed SSRS-40200 - The header seems to be missing when setting HisOption as 2

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

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

Please let us know your run result.

Thank you.

29

Hi,


And, we have
used Aspose.Cells for Reporting Services (SSRS2008) V2.1.0.20 (please download it in previous post in this thread) to test against the issue SSRS-40201 and it is Ok.

SSRS-40201 - After setting HisOption as 2 then clicking the cell ignores the rs:Format parameter when opening the hyperlink into the browser

Please let us know
run result

30

The issues you have found earlier (filed as SSRS-40201;SSRS-40200;SSRS-40179;SSRS-40165) have been fixed in this update.

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