http://reddymsbitools.blogspot.com

Thursday, 28 October 2010

Custom Code for color display in the SSRS report

Public Function GetColor(ByVal status as String) as String
IF status = "Closed - Converted" Then
Return "White"
End IF
IF status = "Closed - Not Converted" Then
Return "Yellow"
End IF
IF status = "Open - Not Contacted" Then
Return "Tomato"
End IF
IF status="Working - Contacted" then
return "Red"
end if
End Function
------------------------------------------------------
select the column for display the color
=code.getcolor(Fields!color.value)
-----------------------------------------------------------

No comments:

Post a Comment