Aspose.Cells for Reporting Services 24.2.0
Is it possible to have a static validation list in a cell? When I export to XLSX the output is blank in that column.
Also, is it possible to have a hyperlink in a column with a dataset field as a parameter in the URL?
@berlblack ,
Thank you for using Aspose.Cells Reporting Services.
We will promptly evaluate your business requirements and would appreciate it if you could provide a Demo report to help us better understand your needs.
Hello,
In columns L and M there are validation lists that, when rendered as XLSX, are not in the spreadsheet. I’ve tried having those columns in the attribute range and out of it and it doesn’t work in either case.
In column E there is a hyperlink that needs a parameter appended with a field from the dataset. The hyperlink is not present when rendered.
Also, I would have uploaded the file with my original post but I didn’t see how to do that.
One more thing. Every time I open Excel, I need to reenter the report server URL and credentials. I also need to browse for the data source and re-select it even though it appears populated in the form. If I don’t do that, the publish report step fails. Is there a way to persist these things.
Kind regards,
Berl
(Attachment Undelivered_Report.rdl is missing)
Please zip the files before attaching them here. Use the “Upload” button/icon in the Reply window/frame to upload the files. Also, zip and attach your current output XLSX file and your expected XLSX file for reference. We will look into it soon.
@berlblack
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSRS-723
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
We have fixed the issue (logged as “CELLSRS-723”) regarding validation list and hyperlinks in Aspose.Cells for Reporting Services. Could you try our latest version/fix:
Let us know your feedback.
It looks like there is only a 32 bit version of the update on the downloads website. I’m running a 64-bit version of Excel. After installing the client via the MSI, I get the following error message when trying to open a report from the Aspose.Cells menu in Excel:
Set AsposeClientTools = CreateObject(“Aspose.Cells.ReportingServices.Client.AsposeClient”) - Run-time error ‘-2147221165 (80040154)’: Class not registered.
I have tried to register the client dll manually but still get the same error.
Yes, 64-bit version of Aspose.Cells for Reporting Services v24.4 is missing in the Downloads section. We will check and get back to you soon.
Unfortunately, I’m still getting the same error after installing the x64 version.
igxqbO3qhu.zip (44.2 KB)
Any suggestions?
Thanks for your feedback.
We will look into it soon. Also, please share your environment details including MS Excel version, SQL Server, and OS, etc. By the way, could you please re-register the Aspose.Cells for Reporting Services client add-ins manually? Make sure to uninstall it and unregister the existing one (via regasm.exe utility) first, see the document for your reference.
@berlblack ,
This version addresses the Aspose.Cells.ReportingServices.DLL issue on the server side. Users can continue using the previous version on the client side. To upgrade to the latest version, uninstall all previous versions, restart your computer, and install the version. If the issue persists, you can run the following command with administrator privileges
C:\Windows\Microsoft.NET\Framework64\v2.0.50727\RegAsm.exe "C:\Program Files \Aspose\Aspose.Cells for Reporting Services\Bin\Aspose.Cells.ReportingServices.Client.dll" /tlb Aspose.Cells.ReportingServices.Client.tlb /codebase
Using regasm got the client to work except that now I cannot test the changes in the new version because I cannot publish reports. I get publishing report failed messages.
From the Aspose client log:
Process(1) ASPOSE Alert : : Friday, May 3, 2024 10:54:55 AM : An internal error occurred on the report server. See the error log for more details. —> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Aspose.Cells.ReportingServices.Services.ReportingService2010.ReportingService2010.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
From the Report Server SQLDmpr log:
library!ReportServer_0-1!1730!05/03/2024-09:56:07:: i INFO: Call to ListChildrenAction(/, True).
library!ReportServer_0-1!d90!05/03/2024-09:56:09:: i INFO: Call to GetItemTypeAction(/Datasets/DefaultDates).
library!ReportServer_0-1!d90!05/03/2024-09:56:09:: i INFO: Call to GetDataSetItemReferencesAction(/Datasets/DefaultDates).
library!ReportServer_0-1!d90!05/03/2024-09:56:09:: i INFO: Call to GetItemTypeAction(/Datasets/DefaultDates).
library!ReportServer_0-1!d90!05/03/2024-09:56:09:: i INFO: Call to SetDataSetItemReferencesAction(/Datasets/DefaultDates).
library!ReportServer_0-1!d90!05/03/2024-09:56:10:: i INFO: Call to CreateReportAction(Undelivered_Report, /Test, True).
library!ReportServer_0-1!d90!05/03/2024-09:56:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: DataSet Drivers not found, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;
I’ve copied the SSRS2008R2 version of the dll to the ReportServer\bin folder. In the properties of the dll the file version is 24.4.0.0. As you can see in the attached image, the XLSX options do not appear in the exports list. I tried using the SSRS2016 version but none of the Aspose formats appear then and publishing reports also fail.
The server and report server versions are also attached. SQL Server version is 2012 as well.
berlblack.zip (67.2 KB)
Thank you for providing the screenshots and log details. We are sorry that you still are experiencing the issue. We will look into it and get back to you soon.