Solved

Multiple Conditional Formatting in SSRS

Posted on 2009-04-06
1
884 Views
Last Modified: 2012-05-06
I have a report in SQL Server Reporting Services 2005. I already have this condition set in the COLOR property. It is checking the field called "SalesRep".

=iif(Fields!SalesRep.Value = ".Bluebird - (New Client)", "Blue", "Black")

I now need to check another field called "Status", and if the status is RESCHEDULED I want to make the row Green. How would I make this expression work?
=iif(Fields!SalesRep.Value = ".Bluebird - (New Client)", "Blue", "Black")
=iif(Fields!Status.Value = "Rescheduled", "Green", "Black")
0
Comment
Question by:pzozulka
1 Comment
 
LVL 16

Accepted Solution

by:
Auric1983 earned 500 total points
ID: 24079866
Assuming because you're setting the row colour one would take precidence over the other?
This would check if its a new client, if yes the row will be blue, otherwise it will check for a rescheduled entry and be green... finally if its neither it will be black.

=iif(Fields!SalesRep.Value = ".Bluebird - (New Client)", "Blue", iif(Fields!Status.Value = "Rescheduled", "Green", "Black") )

0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Permissions on Database 11 37
My Query is not giving correct result. Please help 5 30
Sql query 107 27
SQL 2008 R2 calc date formula 3 26
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now