Custom Report Group by User

I have void report like this

  [Voids Detail:1,1,1,1,1.8, 0.7, 1,1,1,0.6]
   >User|Ticket|Date|Time|Product|Quantity|Total|Reason|Department
   {REPORT ORDER DETAILS:OSU.GStatus,T.TicketNumber,OSD.GStatus,OST.GStatus,O.MenuItemName,O.Quantity,O.TotalPrice,OSV.GStatus,O.Department:(OS.GStatus=Void)}

How to Group report byUser / OSU.GStatus?

Geez we need to invent a way for this forum to auto format reports etc lol. Anyway in all seriousness try something like this:

@{REPORT ORDER DETAILS:O.User,O.TotalPrice:(OS.GStatus=Void):{0}:,} 
[Voids Detail by $1:1,1,1,1.8, 0.7, 1,1,1,0.6]
{REPORT ORDER DETAILS:T.TicketNumber,OSD.GStatus,OST.GStatus,O.MenuItemName,O.Quantity,O.TotalPrice,OSV.GStatus,O.Department:(OS.GStatus=Void) AND (OU=$1)}
3 Likes

So, How to make report Group By User?

I edited my post to show that last.

why the void item show repeat 6 times

Did you solved it? Can you try this?

@{REPORT ORDER DETAILS:O.User,O.TotalPrice.sum:(OS.GStatus=Void):{0}:,} 
[Voids Detail by $1:1,1,1,1.8, 0.7, 1,1,1,0.6]
{REPORT ORDER DETAILS:T.TicketNumber,OSD.GStatus,OST.GStatus,O.MenuItemName,O.Quantity,O.TotalPrice,OSV.GStatus,O.Department:(OS.GStatus=Void) AND (OU=$1)}