I have a report with at tablix, built using SSRS 2008. I have an expression to hide a column if the column header has a length of 0. When I render the report using the SSRS built in Excel renderer, the hidden column stays hidden and everything displays correctly. When I use the Aspose.cells renderers, either xls or xlsx, the hidden column becomes visible and the data values in one row are missing. I have attached the .rdl file. Any help or suggestions are greatly appreciated.
Hi,
Thanks for considering Aspose and reporting this issue.
Please also test your issue with the latest version https://downloads.aspose.com/cells/reportingservices and let us know your feedback.
Where should I be putting the new dll file? I have updated the dll file in the following path C:\Program Files\Aspose\Aspose.Cells for Reporting Services\Bin\SSRS2008
Hi,
Please copy the dll at the following folder:
${SQL Server for Reporting Services} \Reporting
Services\ReportServer\bin
The issues I ran into before were during my development and happened when I rendered my report from within Visual Studio. I have completed my report development and am now running the report from Report Manager. I have run into some new issues rendering the report using the Aspose xls and xlsx file formats. When I export my report as Aspose xls or xlsx the appropriate file is created but when I open it I receive the following
Hi,
I have applied the new dll as instructed and am still having the same issue. I have attached the rdl file, a xls file rendered using the SSRS built in Excel renderer and a xlsx file rendered using the Aspose xlsx renderer.
Hi,
Thanks for your files and testing it with latest version. We have added this issue in our database. We will investigate it and fix it asap.
This issue has been logged as SSRS-40001.
the source of my issue was having an expression on the hidden property of my column group. When I removed that expression and set it to always show, the report renders correctly.
Hi,
Thanks for your feedback.
We have found this issue and we will fix it asap and update you.
Hi,
Please try the fixed version v1.7.0.59 (attached) for SSRS 2008.
I have applied the new dll and I am no longer receiving errors when I render a report. But, merged cells are being unmerged and that is messing up my report formatting.
Hi,
Hi,
Please let us know how many cells are in your exported excel file.
When cells number are more than default value(1,000,000), merged cells will un-merge.
Please refer follow context to set LimitCellsNumberForMerged value in Aspose.Cells.ReportingServices.xml file.
==============================================================================================================
===============================================================================================================
The issues you have found earlier (filed as SSRS-40001) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.
Hi, We are facing thsi problem as well. W ehave an excel exported using SSRS on which we use Aspose.cells to perform Zoom settings . The collapsed columns in SSRS Export are automatically expanded on proceesing through Aspose.cells.
The expansion happens automatically as soon as the workbook is initialized
Workbook workbook = new Workbook(reportInfo.FullName);
Here are the details from wath where 0.0 width is expanded to a random value of 8.42…
GroupLevel 0 byte
Index 3 int
IsHidden FALSE bool
Style {Aspose.Cells.Style} Aspose.Cells.Style
Width 8.428571429 double
Hi,
Thanks for your posting and considering Aspose.Cells for Reporting Services.
Please create a separate thread with good detail of your issue. And also provide screenshots (if relevant), rdl file and exported excel file. We will look into your issue and log it in our database for a fix. Thanks for your cooperation.