{"id":113,"date":"2012-02-15T02:57:28","date_gmt":"2012-02-15T02:57:28","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=113"},"modified":"2014-03-06T15:38:09","modified_gmt":"2014-03-06T15:38:09","slug":"data-driven-colored-text-for-reporting-services-reports","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/data-driven-colored-text-for-reporting-services-reports\/","title":{"rendered":"Data Driven Colored Text for Reporting Services Reports"},"content":{"rendered":"

In SSRS you can use data driven expressions to color code certain rows. This post will show you how to accomplish this.<\/p>\n

First thing is first. I\u2019m assuming you already have a report created. In this example, I\u2019m using the AdventureWorks database and I\u2019m running a report on Name, Email, Hire Date, Title and Pay Rate:<\/p>\n

\"SQL<\/a><\/p>\n

Formatting Needs<\/h3>\n

I want to distinguish three different levels of pay. If the Employee makes $10.00 or less I would like to change the text Red. If the employee makes between $10.01 and $20.00 I would like to keep the text Black and if the employee makes more than $20.00 I would like to change the text Green.<\/p>\n

Changing Text Color<\/h3>\n

First, go to the Design tab of Designer view and select all the fields in which the color of text needs to change. In this example, I’ll select all fields.<\/p>\n

\"SQL<\/a>
\nNext, I’ll go to the Properties Window. If you don’t see this window you can choose View, Properties or simply hit F4.<\/p>\n

In the Properties Window click the arrow beside Color<\/strong> and choose Expression<\/strong>:<\/p>\n

\"SQL<\/a><\/p>\n

In the Expression box type your VB expression and click OK. In this example I’m using the following:<\/p>\n

\n
=SWITCH(Fields!Pay.Value <= 10, \"Red\", Fields!Pay.Value >= 20, \"Green\")<\/pre>\n<\/div>\n
\"SQL<\/a>
\nClick here to view the rest of this post.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
In SSRS you can use data driven expressions to color code certain rows. This post will show you how to accomplish this. First thing is first. I\u2019m assuming you already have a report created. In this example, I\u2019m using the AdventureWorks database and I\u2019m running a report on Name, Email, Hire Date, Title and Pay […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,29],"tags":[35,106,59,41,32,31],"class_list":["post-113","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-reporting-services-ssrs","tag-bi","tag-business-intelligence","tag-development","tag-expressions","tag-sql-server-reporting-services","tag-ssrs"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=113"}],"version-history":[{"count":1,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/113\/revisions"}],"predecessor-version":[{"id":118,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/113\/revisions\/118"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}