ssouth
February 27, 2012, 12:26pm
1
Our team is using SSRS - Matrix to formulate reports with multiple cells reflected with different colors based on calculations. However, when we export to: Excel 2007xlsx via Aspose Cells, and XLS Excel Workbook via Aspose Cells - the report converts all the cells to "red." Is there anyway to resolve this?
FYI - When we test this scenario using Export to PDF via Aspose - works successfully. When we export to PPT Aspose Slides works great except for the watermark issue with Slides version 4.0.
Hi, Please update performance configuration in Aspose.Cells.ReportingServices.xml file. ===========================================================================
<Performance value =“ON” IsAutoRowFit =“True” IsMerged=“True” IsSetStyle=“False ” IsConditionalFormatting =“False”>
<AutoRowFit value =“True”/>
<SetStyle value =“False ”/>
<Merged value =“True”/>
<ConditionalFormatting value =“True”/>
============================================================================
If you still face the issues, please post your report define file here.
ssouth
February 29, 2012, 3:44pm
3
Shakeel, I do not see an Aspose Cells Report Services XML file - any suggestions?
Hi, Please try to locate it at this folder: ${SQL Reporting Services}\Reporting Services\ReportServer\bin Or try searching it using *.xml
Hi, How did you install Aspose.Cells for Reporting Services ? Please try finding Aspose.Cells.ReportingServices.xml file in following folder: ${Aspose.Cells for Reporting Services installation folder}. If you could not find, then please download and try the latest version:
Aspose.Cells
for Reporting Services v1.8.0.12 (MSI)
ssouth
March 2, 2012, 2:38pm
6
Shakeel - we were able to use the performance code listed above for the configuration xml file - but the multiple excel cells still show as one color.
Hi, Please download and try the fixed version: Aspose.Cells for Reporting Services V1.8.0.13 . Please uninstall the previous version, deleted all dll’s and re-install it, it should work fine then. Please let me know your feedback.