This report:
{REPORT MENU ITEM TAG DETAILS:M.Name, T.Name, T.Value}
shows the entire list of Products including all the custom tags and their value for each product.
How can I get the product name and the value of an specific Tag named “Combos”? This does not work:
{REPORT MENU ITEM TAG DETAILS:M.Name, T.Value:(T.Name=Combos)}
Field ‘describers’ and constraint expressions are not always identical…
You can sometimes used field names without the brackets as a’constraint on reports (but not always) ie;
{REPORT MENU ITEM TAG DETAILS:M.Name, T.Value:T.Name=Combos}
T.Name=Combos does not work
I have tried so far:
{REPORT MENU ITEM TAG DETAILS:M.Name, T.Value:T.Name=Combos}
{REPORT MENU ITEM TAG DETAILS:M.Name, T.Value:(T.Name=Combos)}
{REPORT MENU ITEM TAG DETAILS:M.Name, T.Value:(T.Name=‘Combos’)}
Did say it doesnt always work…
Look here for idea;
Append this to the end of Item Sales Report.
[Order Tag Details:8, 2, 3]
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER TAG DETAILS:O.MenuItemName,T.Qty.Sum.desc;#,([T.Price]*[T.Qty]).sum;'#.##;-#.##;-':(ODI=True) and O.MenuItemName="$1" and O.OrderTags != "" and O.OrderTags != null}
{REPORT ORDER TAG DETAILS:T.Value,T.Qty.sum;#,([T.Price]*[T.Qty]).sum;'#.##;-#.##;-':Order.MenuItemName="$1" and (ODI=True)}
I still don’t know if it is what you need.…
O.OrderTags = Combos
Wasnt that far down on a search for ‘REPORT MENU ITEM TAG DETAILS’…
1 Like