Items in a Report `@list` which contain "and" breaks Report

[QMcKay]

Originally reported in another Topic, created an Issue Topic for this:

Item Sales report ODI = True strange results

Has anyone else come across this issue Some items are being excluded. In this example I have Sold 1 Bacardi Rum and 1 Hennessy Brandy and also voided 1 Bacardi Rum [Capture] [Sales by Group non VOID:2, 1, 1, 1] {REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent.desc,O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True)} >Total|{REPORT ORDER DETAILS:O.Blank,O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True)} [Item List:5, 2, 2,1] {REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:|} …

@silentbob

it seems to be the “and” in the MenuItemName that is breaking it Removing the “Br’and’y” from the “Hennessy Brandy” fixes the issue. Surely this is a bug.

@silentbob

Try this

@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:|}
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:O.MenuItemName="$1"}
{REPORT ORDER DETAILS:'     '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:O.MenuItemName="$1":2}