Data Driven Text Color with Reporting Services

Going beyond the standard green bar example, in this video Pam shows you how to use an expression to change the background color of the rows on a report based on multiple conditions. Learning to use basic expressions can really supercharge your reporting skills!

Pam Shaw has been in IT for over 27 years. For the last 8 years, She has been working with SQL Server, first 2000 and then 2005. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS.

rupesh sharma on 2/16/2009

It is good and having seen this I think I should also create such videos.

Carl Draves on 2/16/2009

Was helpful.

Kenneth Wymore on 2/16/2009

It would have been nice to see a couple of different examples of formatting using the IIF statement such as setting the font to bold for movies under a certain genre while performing the color changes for other rules.

ML Stephens on 2/16/2009

great just a little step to make things jump out

Ed Greenawald on 2/16/2009

Use Switch statement instead of nested iif. Easier to read. See http://msdn.microsoft.com/en-us/library/aa261864.aspx

Stephanie Brown on 2/16/2009

A nice clear snippet, and a good reminder of how powerful Reporting Services can be with a little creativity.

Shireesha on 2/16/2009

:)

Tariq Bilal on 2/17/2009

nicely explained

1AFA31864B on 2/17/2009

would like to see more on conditional formatting, and explaining the code a little more

WChaster on 2/17/2009

Well the pop-up quiz came up so quick I thought it was an attack, it cut of the commentary.

Tracy Smith on 2/17/2009

I love it

Jon Crowell on 2/18/2009

the presenter seems a little bored

edu on 2/18/2009

BUEN EJEMPLO -PERU

Venkata Taduri on 2/27/2009

Good one.

Dean Gross on 3/3/2010

it would be nice if this were extended to show how this would done using Code so that it could be reused between reports in a solution