Solved

Conditional Formating in SSRS resport.

Posted on 2010-11-29
2
360 Views
Last Modified: 2012-05-10
How do you write conditional formating where you have a value within a range?  Say you want the color to be orange if the number is between 0.80 and 1.09

This is what I have

=SWITCH(Fields!Total_Point.Value <= 0.80,"#ccffff",
Fields!Total_Point.Value > 0.81,"Orange",
Fields!Total_Point.Value <= 40,"Black",
Fields!Total_Point.Value > 40,"Red")

Thanks
0
Comment
Question by:NickMalloy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
hosneylk earned 250 total points
ID: 34236112
have you tried this?
Fields!Total_Point.Value > 0.80 And Fields!Total_Point.Value < 1.09

Open in new window

0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 34241699
IIf.  The first is true value, the second is false value ... but the false value can also be another IIf :-) .

IIf(Fields!Total_Point.Value <= 0.80, "<color name>/value",
IIf(Fields!Total_Point.Value > 0.81 AND Fields!Total_Point.Value < <_value_>,"Orange",
IIf(Fields!Total_Point.Value <= 40,"Black",  ... )))...
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question