Wednesday, June 8, 2011

SSRS (Reporting Services) Excel Friendly Check Mark

Indicators are nice, but what if the users what to do their own manipulation of the data through Excel?  You cannot sort or filter by an indicator so you have to use a ASCII friendly symbol. 

=IIF(Fields!Is_Orphaned.Value = 1,
=IIF(Fields!Is_Orphaned.Value = True,
=IIF(Fields!Is_Orphaned.Value = "1",chr(0254),Nothing)
"√", Nothing)
"√", Nothing)

No comments:

Post a Comment