I have installed the trial version and I am trying to export a report to Excel that has encryption enabled. I have modified the "Aspose.Cells.ReportingServices.xsl" file and have enabled the encryption option according to the documentation. When I export to any version of Excel it creates the file correctly but there is no password displayed when the file is opened in Excel.
I have attached the configuration file taken from "C:\Program Files\Aspose\Aspose.Cells for Reporting Services".
Am I missing something in the configuration file?
Thanks
Steven
Hi Steven,
Thanks for your posting and using Aspose.Cells for Reporting Services.
We were able to observe this issue. We have logged this issue in our database for investigation. We will look into it and fix 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-40178.
Hi,
We have found the issues and fixed them.
Please try the fixed version (attached): Aspose.Cells for Reporting Services (SSRS2008) V2.1.0.9.
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.
Hi
Thank you for the update.
I have copied the new dll into the location specified but when I export the report I get the following error on the first tab of the Excel spreadsheet:-
| An error occurred while exporting the report. |
| error message |
Row number or column number
cannot be zero |
| stack trace |
at ..( , Int32 , Int32
, Int32 , Int32 )
at ..(Int32 , Int32
, Int32 , Int32 )
at ..(Int32 ,
ReportElement )
at ..()
at ..(Int32 ,
ReportElement )
at ..()
at ..( )
at
Aspose.Cells.ReportingServices.Renderer.(Report ,
NameValueCollection , NameValueCollection , NameValueCollection , Hashtable&
, CreateAndRegisterStream )
at
Aspose.Cells.ReportingServices.Renderer.Render(Report report,
NameValueCollection reportServerParameters, NameValueCollection deviceInfo,
NameValueCollection clientCapabilities, Hashtable& renderProperties,
CreateAndRegisterStream createAndRegisterStream) |
Thanks
Steven
Hi,
Please post your report define file and Aspose.Cells.ReportingServices.log file here.
We will check it ASAP.
You can find the log file in the following folder: ${Aspose.Cells for Reporting Services installation folder}.
Thank you.
Hi
I have attached the files as requested.
Thanks
Steven
Hi Steven,
Thanks for your posting and using Aspose.Cells for Reporting Services.
Are you getting exception for every type of RDL file or with only this particular RDL file (i.e QBE MI Report.rdl)?
Hi Steven,
Thanks for using Aspose.Cells for Reporting Services.
We have tested your provided report definition file. But we did not find your issue.
Could you tell us detail information for this issue?
e.g.
1. Post the exported report which is exported by the default excel rendering here .
2. Update logger level in Aspose.Cells.ReportingServices.xml and get new log file.
========================================
========================================
3. What kind of data caused the error excel file?
Hi,
We have fixed the issue for Row number or column number cannot be zero.
Please try the fixed version: Aspose.Cells for Reporting Services V2.1.0.17(SSRS2008).
Please copy Aspose.Cells.ReportingServices.dll into following folder:
${SQL Server 2008 Reporting Services}\Reporting Services\ReportServer\bin.
Please let us know your run results.
The issues you have found earlier (filed as SSRS-40178) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.