September 16, 2015 at 10:25 am
In an ssrs 2012, there is an problem when the report is exported to excel when running on a ssrs 2012 report server. When the report is generated, selected cells are highlighted. When the report is exported to a PDF file, the correct selected cells are highlighted with a background color.
However when the report is exported to excel on the report server, all cells are highlited from the first point of where the individual cells are highlighted to the end of the data. For example, if row # 5 has a cell highligted in column D then all rows from row #5 to the end have in column D are incorrectly highlighted.
When I run the rdl on my workstation, there are no export problems. The report server exports excel files to an *.xls file and my workstation also exports the excel file to an *.xls file also. However I do have office 2013 on my workstation.
Note: The code that is causing this highlight the background color for a cell is the following:
=IIF(Fields!IndicatorCount12.Value > 0, "LightSteelBlue" , nothing). This is the code in the background property of the applicable cell.
Thus would you tell me and/or point me to a url that will tell me how to solve this problem?
September 17, 2015 at 8:37 am
This is a Microsoft known problem.
September 18, 2015 at 7:53 am
Make sure you set the color value in the else part. Here is code I use to set the background color for a row:
=IIf(Parameters!Program.Value = "ALL",
Switch(Fields!CurrentClub.Value = 1, "DarkGray"
,Fields!CurrentClub.Value = 5, "DeepPink"
,Fields!CurrentClub.Value = 10, "Red"
,Fields!CurrentClub.Value = 15, "Yellow"
,Fields!CurrentClub.Value = 20, "LightGreen"
,Fields!CurrentClub.Value = 25, "Turquoise"
,1=1, "White"
), "White")
I set the background to "White" when it should not be highlighted, I tried setting to a NoFill type value but couldn't quite get that to work.
Try the above and see if that resolves your issue.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply