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

**URL:** <https://forum.sambapos.com/t/items-in-a-report-list-which-contain-and-breaks-report/17434>\
**Category:** V5 Issue\
**Created:** [May 4, 2018, 2:51pm UTC](https://forum.sambapos.com/t/items-in-a-report-list-which-contain-and-breaks-report/17434 "2018-05-04T14:51:43Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [May 4, 2018, 2:51pm UTC](https://forum.sambapos.com/t/items-in-a-report-list-which-contain-and-breaks-report/17434/1 "2018-05-04T14:51:43Z")

</div>

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

> [@Item Sales report ODI = True strange results](https://forum.sambapos.com/t/item-sales-report-odi-true-strange-results/17158):
>
> 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}:|} …

> [@Item Sales report ODI = True strange results](https://forum.sambapos.com/t/item-sales-report-odi-true-strange-results/17158/2):
>
> 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.

> [@Item Sales report ODI = True strange results](https://forum.sambapos.com/t/item-sales-report-odi-true-strange-results/17158/4):
>
> Try this
> 
> ```auto
> @{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}
> 
> ```
