On systems where UAC is enabled, when an application (like SSIS) is launched by an account that is a member of the Administrators group, it gets two security tokens, one...

Thank you! This worked, the field was really a space.

=IIF(Fields!ALF.Value = " ","ZZZZZZ", Fields!ALF.Value)

That is what I did in the Crystal report equivalent, but it didnt work here. It says the expression is invalid. I also tried this: =Switch(IsNothing(Fields!ALF.Value),"ZZZZZZ",...

Did that work for you? I need to sort AtoZ then blanks at the end, but

I cant get this to work:

=SWITCH(Fields!ALF.Value = " ", 2,Fields!ALF.Value like "%",1,)

This works when I add a dateparm that gets todays date. The team parameter list is refreshed when I add that dateparm.