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.
[Sales by User:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.User.asc:(ODI=True):,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1):{0}:,}
>>$1
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1) and O.MenuItemName="$2"}
{REPORT ORDER DETAILS:' '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1) and O.MenuItemName="$2":2}
This now works in v5.2.14 otherwise in v5.2.12 it had a high cpu usage and was breaking the report. I just tried on the new release and it works fine. Thanks for this.
I tried to use this in my terminal but did not work. What’s wrong? I just copy-paste code by @emre into the program, maybe I need change some parameters?
Latest release version is 5.2.14 you should install that. 5.2.12 is older In fact in this very thread just above where you asked your question someone mentioned that it worked fine in 5.2.14 but in 5.2.12 it didnt. Did you not see that?