Join (concatenate) report values into a single column

V5 Question
1

I couldn’t find a solution on this, but I was able to pull it together through different posts. The bar mainly uses customers and the cafe uses tables. We’re building a report for voided items and its helpful to have the customer/table detail. Given the width of the ticket printer saving room in the columns is important. Therefore, I’m joining the table and customer into a single column. To do this you can use:

([Report Value] + ’ - ’ + [Report Value])

Example Report Section:

[Void Report:2,2,1,1,1,1]
>Date|Cust-Tab|Item|Amount|Type
>{REPORT ORDER DETAILS:O.Date,([EN.Table] + ’ - ’ + [EN.Customer]),O.MenuItemName,O.TotalPrice,OSV.GStatus:(OS.GStatus=Void) AND (TEN.Server={SETTING:CURRENTUSER})}
>Total: {REPORT ORDER DETAILS:O.TotalPrice.Sum:(OS.GStatus=Void) AND (TEN.Server={SETTING:CURRENTUSER})}

JCR

1 Like
2

There is also a way to do this with the following format.

[Report:1,1]
>Name|Date Amount
{REPORT TICKET DETAILS:EN.Name,T.Date,T.TotalAmount::{0}|{2} {1}}

Notice last field the 2 and 1 designation.

1 Like