Dynamic formatting within the reports using TSQL?

Published 03 October 07 02:56 AM | SQL Master 

I felt this is more about SQL Storage engine related blog, but there is blend of TSQL involved in tasking the dynamic reporting within the Reporting Services.

Here it goes, the task is to change/highlight the color of a row, based on its value.  Therefore, if a column value is say greater that 90%, the cell should be RED color.

You can achieve this by modifying the color property of the field (on Report Builder)

=iif(Fields!MyField.Value > 85, "Red", "Black")

Further information on how this can be achieve refer to http://msdn2.microsoft.com/en-us/library/ms156400.aspx link.

Comments

# Other SQL Server Blogs around the Web said on October 3, 2007 3:09 AM:

I felt this is more about SQL Storage engine related blog, but there is blend of TSQL involved in tasking

# SSQA.net - SqlServer-QA.net said on October 3, 2007 3:57 AM:

I felt this is more about SQL Storage engine related blog, but there is blend of TSQL involved in tasking

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.