CODEWITHSUNDEEP
reporting-servicesreportingservices-2005
Dibstar
Dibstar

Reputation: 2364

Reporting services knowing how a colour will appear in excel export

I have been playing around with some reports and exporting them to excel, only to find that the colour in SSRS is not even remotely close to that in excel - for example if I have a textbox that is PaleGreen is SSRS, it comes out a rather unpleasant shade of grey.

Is there a way of knowing which SSRS colours will look the same in excel exports so I can stick to those? I'm using SSRS 2005 and excel 2003 (but can use Excel 2007 if it helps).

Thanks!

Upvotes: 0

Views: 1808

Answers (2)

niktrs
niktrs

Reputation: 10056

Seems to be excel 2003 limited palete problem.

A workaround could be:

Open excel 2003, choose a color and check it's RGB values, and convert them to HEX

In reporting services use the HEX value as background color.

You can find an online DEC to HEX converter here: http://www.mathsisfun.com/binary-decimal-hexadecimal-converter.html

Upvotes: 2

mameesh
mameesh

Reputation: 3761

Sounds like this is caused by the algorithm that is used to match the reporting services colors up to the excel color pallet. There is no fix for this. I usually tend to try to use basic colors Silver, White, Blue, etc. to avoid these issues.

http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/c592e7ac-84a4-4dc1-9c82-bd1657e7a9b4

Upvotes: 1

Related Questions