SSDT is a cutting-edge development tool for creating relational databases in SQL Server, databases in Azure SQL, data models in Analysis Services (AS), packages in Integration Services (IS), and reports in Reporting Services (RS).
Yes, it’s one of my favorite tools, and I’ve worked on it with great pleasure for many years while producing reports for reporting services.
This site has a lot of articles about SSDT and SSRS that will give you in-depth knowledge about how to use them. In this article, you’ll know how the values in the cell can be highlighted based on the conditions.
Once you select a cell, go to its properties, expand Fill, and you’ll see “BackgroundColor” listed. Its value is “No Color” by default. Click on it to provide an expression.
Any of the examples below may be used.
Using IIF
When determining if a statement is true or false, the IIF function makes a decision and returns one of two results.
To return one of three values based on the value of TotalAmount (a column as specified below), use several IIF functions (sometimes referred to as “nested IIFs”).
Use the following equation in a text box’s fill color to modify the backdrop color based on the value entered there.
=IIF(Fields!TotalAmount.Value>=10000,”Green”,
IIF(Fields!TotalAmount.Value>=5000,”Yellow”,
IIF(Fields!TotalAmount.Value<=1000,”Red”,”No Color”)))
Using SWITCH
IIF can be substituted with the SWITCH function. When you have three or more conditions to test, the Switch function is helpful.
=Switch(Fields!TotalAmount.Value >= 10000, “Green”,
Fields!TotalAmount.Value >= 5000, “Yellow”,
Fields!TotalAmount.Value <= 1000, “Red”)
Hope you find this article helpful.
Big Data & SQL 