Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jfrennch1999
Starting Member
3 Posts |
 Posted - 2014-07-03 : 18:28:26
|
| I am trying to format my bottom line which are my totals. I am using the following expression to change my back ground. It works great until it runs into columns that have zero in it and goes to the false color which is light blue. =IIf(Fields!EndPoint.Value="Total Sales Division" or Fields!EndPoint.Value="Total End Point" or Fields!EndPoint.Value="Total IP-Relay" or Fields!EndPoint.Value="Total ClearCaptions","CornflowerBlue",iif(Fields!Projection.Value="Actual","LimeGreen","LightBlue" ))I used the expression =iif(isnothing(Sum(Fields!MnthSum.Value)),0,Sum(Fields!MnthSum.Value)) to put in zero'sI tried something like this as a test and it changed everything in this section to light blue.=IIf(Fields!EndPoint.Value="Total Sales Division" and Sum(Fields!MnthSum.Value)=0 or Fields!EndPoint.Value="Total End Point" or Fields!EndPoint.Value="Total IP-Relay" or Fields!EndPoint.Value="Total ClearCaptions","CornflowerBlue",iif(Fields!Projection.Value="Actual","LimeGreen","LightBlue" )anyone have any suggestions. Thanks |
|
|
|
|
|
Background formatting using iffs