SSRS Background formatting skipping zero

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.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

SSRS Background formatting skipping zero

Author

Topic

jfrennch1999
Starting Member

3 Posts

Posted - 2014-07-02 : 13:32:12

I am using the following to change cell colors under background color

=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 am also using this express to handle blank cells

=iif(isnothing(Sum(Fields!MnthSum.Value)),0,Sum(Fields!MnthSum.Value))

The background does not apply the CornflowerBlue where 0 are inserted it goes to light blue in this example. Do I need to build in my second formula into by back ground? How do I do that. The background is working where is am not using isnothing. Thanks in advance .

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2014-07-07 : 22:46:53

Can you try this approach. right click the textbox properties. Under Fill color expression put this codes.
You can modify this codes based on your requirements.

=Switch(Fields!PurchStatus.Value="Open Order","Green"
,Fields!PurchStatus.Value="Received","Blue"
,Fields!PurchStatus.Value="Delivered","Gray"
,Fields!PurchStatus.Value="Cancelled","Red")

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2014-07-07 : 23:54:25

Please try this codes. hope this will help you.


=Switch(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"
,Fields!Projection.Value="Actual","LimeGreen","LightBlue")

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources