I have SSRS Reports created and rendering in Excel format. I used a custom color(mentioned in excel spec R23, G123, B87) in SSRS. But it shows a different color with the same combination in SSRS. And once I render the report to Excel it shows the color different though I used the same color combination.
Why the color difference in Excel and SSRS? How do I solve this?
The standard Microsoft Excel 2003 color palette has 40 colors plus 16 colors for chart fills and lines. Most of the current builds of Business Intelligence reporting systems (Cognos Series 8, Business Objects XI R3, Reporting Services 2000/2005, etc.) automatically translate colors to the "closest matching" Excel 2003 color palette selection as part of the render to Excel method. This can be very frustrating for Office 2007 users given that Excel has virtually unlimited color palette choices by default.
Reporting Services 2008 DOES NOT have this color palette restriction. If you render a report to Excel in Reporting Services 2008, then the colors will match the colors that are displayed in your HTML rendered report.
