Why am I no longer able to sort a task report alphabetically by Assignee?

[Brooke]

We use the task report to track certain action items for a team. In the past I was able to sort by assignee. Now none of the columns I have will sort in any sort of order (random out of sequence due dates vs. being able to sort by oldest to newest or vice versa; assignees cannot be sorted in any type of alphabetical order). There seems to be no rhyme or reason to the sorting functionality now, and it wasn't like that in the past. Any idea how to fix this? 

[Bob Swift]

The Hide macro works with regex matching and you are not going to get a match of myname with $user as both are text values unless you have this included in a run macro where user is one of your user defined variables. 

Milo's answer is appropriate if you are just changing view of content based on users and groups.

[Sandra Rinehart]

Bob Swift, i would like to ask if some Regex examples of what to put directly into the Hide Macro.  I am using very very basic regex and it is not working

I want to hide unless  the current user id on the form is one of several

showif = $current_user_id:csweet|srinehart|wknapp

I have also tried

showif = $current_user_id:(csweet|srinehart|wknapp)

neither have worked

only csweet is shown the panel if i have it as 

showif = $current_user_id:csweet

or

showif = $current_user_id:cweet:srinehart:wknapp

[Milo Test]

You could try the Visibility macro from ServiceRocket. It works for me.