In an existing SSRS 2008 r2 report, my users that use pcs that have a Windows operating system can export their reports to excel using white and a light green color on every other detail line. These users print their reports on a black and white printer and everything is fine.
The problem is for users that work on MAC pcs. These users export their reports to excel and try to print thier reports on a black and white printer. The problem is one line is readable and the other line you can not read. The line that is suppose to be white, is the line that is you can not read.
I believe the problem is due to the color pallete for SSRS reports is different than the color palette that excel uses. I think I would need to make the color pallete that SSRS uses the same as excel uses. Is this a possible solution for every other print line in one SSRS report? If I use the custom colors for this SSRS report, will that also modify other SSRS reports that are generated on the same report server?
Thus can you show me how to change the color pallete that ssrs uses so that it matches the color pallete excel uses? Also if you have other suggestions on how to solve these problem, please let me know what your solution is along with code and/or urls that will tell me how to solve this problem.
- Edited by scampsman Tuesday, November 19, 2013 3:32 PM
As per my understanding, we may meet color issue when we use an expression that resembles the following for the Backgroundcolor properties:
=IIf(Fields!id.Value=5, "Green", Nothing)
In this situation, we can use the expression below to replace the above expression to solve the issue:
=IIf(Fields!id.Value=5, "Green", "White")
Alternative, please check if both the content color and background color are “White”. If so, we cannot see the report data on the “White” line. Please ensure that the content color was set to "Black". So that we can distinguish the content and background.
In SQL Server Reporting Services (SSRS), we can use Custom Palette, Expressions, Custom Code, and Colors from Database to create custom colors.
There is a similar issue, you can refer to it.
Hope this helps.
TechNet Community Support
- Marked as answer by scampsman Wednesday, November 20, 2013 3:06 PM