Solved

Multiple Conditional Formatting in SSRS

Posted on 2009-04-06
1
883 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

757 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

22 Experts available now in Live!

Get 1:1 Help Now