I posted this on POSRoundtable too, but I thought I would try here as well since it’s more heavily visited…
I’m trying to create a report that tells me how many half toppings we sell. I’m attempting to do this by analyzing the “Receipt Description” in the OrderItems table and determining if it starts with “H1” or “H2”
The problem I’m running into is the indent before the child items. Doing a space or tab doesn’t work… anybody know how I need to do the syntax to account for that indent?
Thanks!
I’m trying to create a report that tells me how many half toppings we sell. I’m attempting to do this by analyzing the “Receipt Description” in the OrderItems table and determining if it starts with “H1” or “H2”
The problem I’m running into is the indent before the child items. Doing a space or tab doesn’t work… anybody know how I need to do the syntax to account for that indent?
Thanks!
Last edited: