You would take the list of users on an @ line (copy the one from the work period report and then under use $1 to insert the loop user name:
@{user list copied from wp report}
$1 Item Sales (title for username)
{report order details:field1,field2:(constraint on order user =$1)}
That’s obviously not correct as on phone so can’t check correct expressions but gives you the idea.