Expression based Border Style is not working in Excel (.xlsx) export in SSRS 2017

0
votes

I am facing issue with expression based Borderstyle and BorderColor in Excel Export only whereas same expression is working as expected in web browser, PDF export and report designer. In Detail row-group, row is using expression based Borderstyle to show border "Solid" or "None" but Excel export is completely omitting the expression.

for bottom border Color =IIF(Fields!Show_Underline.Value=1,"Black","White")

for bottom border Style =IIF(Fields!Show_Underline.Value=1,"Solid","None")

Please see below screenshots

Report Output in web browser, PDF export and report designer enter image description here

Report Output in EXCEL

enter image description here

Sample RDL location:

https://drive.google.com/file/d/1MgWExAQqUu2QYBaO4mvZ5QoNV16ob0UB/view?usp=sharing

1
reporting-servicesssrs-2008ssrs-2012ssrs-2008-r2ssrs-tablix

1 Answers

0
votes

Here it is.

Select all three cells and then go to border style default as None but at bottom add below expression

=IIF(Fields!ShowUnderlin.Value=1,"Solid","None")

enter image description here