Application: SSRS

SSRS.AdvancedSorting.txt

/* Interactive Sorting Descending by Numeric */
=Fields!NumericFieldToSortBy.Value * -1

/* Interactive Sorting Descending by Date */
=DATEDIFF("d",Fields!DateFieldToSortBy.Value,Today())


/* Interactive Sorting Descending by String */
=CLNG(CSTR(ASC(UCASE(LEFT(CSTR(Fields!LastName.Value) + "@",1))))
+ CSTR(ASC(UCASE(MID(LEFT(CSTR(Fields!LastName.Value) + "@@",2),2,1))))
+ CSTR(ASC(UCASE(MID(LEFT(CSTR(Fields!LastName.Value) + "@@@",3),3,1))))
+ CSTR(ASC(UCASE(MID(LEFT(CSTR(Fields!LastName.Value) + "@@@@",4),4,1))))
+ CSTR(ASC(UCASE(MID(LEFT(CSTR(Fields!LastName.Value) + "@@@@@",5),5,1))))
) * -1 

SSRS.AlternateBackgroundColor.txt

=IIf(RowNumber(Nothing) MOD 2, "White", "WhiteSmoke") 

SSRS.CheckIfNullOrEmpty.txt

=IIf((Fields!FieldName.Value=""), "Blank Value", (IIf((IsNothing(Fields!FieldName.Value)), "Null Value", "Good Value")))

SSRS.CheckIfSameAsPreviousRecord.txt

=IIf((Fields!FieldName.Value = Previous(Fields!FieldName.Value)), "Match", "No Match")

SSRS.HandleDivideByZero.txt

=IIf(BOTTOM = 0, 0, TOP / IIf(BOTTOM = 0, 1, BOTTOM))