we are upgrading SSRS to 2017 and as I am currently testing aspose as a possible reporting solution I was trying to install the latest version 18.2.3
The MSI install did not modify the configuration files but I then added the required blocks inside the .config files and copied the dll file over but I do not see any of the aspose extensions in SSRS.
Before I spend more time investigating could you please confirm that aspose is compatible with SSRS 2017? I saw in the blog post that aspose for words is compatible with sql server 2017 so I assume it is the same here but just want to be sure.
We are afraid, it is not compatible at the moment but we have logged this task in our database. We will look into it and support it as soon as possible.
This issue has been logged as
CELLSRS-534 - Make Aspose.Cells for Reporting Services Compatible with SSRS 2017
@Amjad_Sahi I have tried to install this version first on 2016 to test the other issues I had but everything is now broken.
Reports are being outputted empty, I have tried to uninstall and revert back to 18.2.1 but it is not working any better.
If I try to recreate a report which is empty with the older version but still getting similar issues, if I return a basic table output without setting the attribute I see the first line. If I set the attribute the output is empty.
Not sure how to troubleshoot and this is obviously causing an issue on my end. How can I make sure ASpose is properly uninstalled? (the installer fails on the server so I just copy the DLL manually)
Please give us your environment details (OS, MS SQL Server, etc.) and capture demo video or series of screenshots to highlight the issue, we will evaluate your issue soon.
but basically everything was working until I tried the new version. Now I cannot create new reports, I went back to version 18.2.3 but it did not fix the issue. Do note that existing reports still function as expected. This is very similar to the issue highlighted there: https://forum.aspose.com/t/total-line-no-longer-appearing/175522/16 were I can see data in SSRS but not in Aspose
pic1:
I can create a simple aspose table
pic2:
if I preview the report first line of data will display data (as expected)
pic3 and pic4:
If I then create the attribute for the codes, and then preview, no data is returned.
pic5:
If I run the same report in SSRS all the data shows.
I have also attached the RDP report. No_data.zip (374.6 KB)
The server is running on SSRS 2016, I am testing on Excel 2010 and 2016
That is strange. We have to look into it but have no clue why it is not working now with even older version (v18.2.3) where it was working before when creating new reports. I think you should try on different machines to evaluate the issue.
Also, I cannot unzip your attached zipped archive which contains the screenshots and report definition file, may be my zip tool is older but it works for other zipped archives. We appreciate if you could zip the files with some different tool and re-attach it again. Also provide us your environment details (e.g OS).
actually not sure if this could be an issue, but in version 18.2.3 the file in Bin\SSRS2016 actually has a version number of 18.2.1 so maybe that has a compatibility issue if excel is then on 18.2.3?
Thanks for the zipped archive containing the RDL file and screenshots.
We need to evaluate your issue thoroughly on your given environment with latest version/fix. We have logged your samples and screenshots against your issue into our database for investigation. Once we have an update on your issue, we will let you know.
And yes, the installer does add stuff into registry especially for client tool (add-ins) for MS Excel. It is best you use installer to install the latest version it should add add-ins to Ms Excel and register certain things fine .
Your findings is right as we noticed the version of Aspose.Cells.ReportingServices.dll assebmly is v18.2.1 when installing the Aspose.Cells for RS v18.2.3 via its installer.
We were able to find the issues. Hopefully we will figure these out before the end of next week. Once the issues are sorted out, we will share the fix for your evaluation.
The issues you have found earlier (filed as CELLSRS-534) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi