Scenario: In SSRS Report display the Employee data, change the background color depends on Employee id like as follows.
1
|
background
color is Red
|
2
|
background
color is Green
|
3
|
background
color is Yellow
|
4
|
background
color is Yellow
|
5
|
background
color is Green
|
6
|
background
color is Red
|
7
|
background
color is Red
|
8
|
background
color is Green
|
9
|
background
color is Yellow
|
10
|
background
color is Yellow
|
11
|
background
color is Green
|
12
|
background
color is Red
|
-
|
--
|
1, 2, 3 are the Employee ID’s
Solution:
• First you create a report by added Adventure Works database to shared Data sources.
• Right click the folder labelled Reports in the solution Explorer. Select AddàNew ItemàReport.rdl
• In the Report Data section, which should be located to the left side of the report and right-click the folder labelled DataSets à Add Dataset.
• In the Dataset select Use a dataset embedded in my report and write the below query on the box.
SELECT
TOP 15 [BusinessEntityID] as EmployeeID
,[NationalIDNumber]
,[JobTitle]
,[BirthDate]
,[MaritalStatus]
,[Gender]
FROM [AdventureWorks].[HumanResources].[Employee]
• Finally the report in the Preview View shows as follows
• Select the Employee data rows in the Design view and Press F4, the properties window will open.
• In the properties window select Background Color àExpressions , and write the below expression.
• And press OK button.
The Output of Report in Preview as shown below.
Let me know what you think about this article.
