SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS Background formatting skipping zero
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jfrennch1999
Starting Member

3 Posts

Posted - 07/02/2014 :  13:32:12  Show Profile  Reply with Quote
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

447 Posts

Posted - 07/07/2014 :  22:46:53  Show Profile  Reply with Quote


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")
Go to Top of Page

Villanuev
Constraint Violating Yak Guru

447 Posts

Posted - 07/07/2014 :  23:54:25  Show Profile  Reply with Quote
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")

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000