Order Tag Details


#1

I have a really silly question here haha…

Ive never done Order Tag reports but I have a client that wants a really basic listing of it. I decided just use

@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:1,1,1,1]
{REPORT ORDER TAG DETAILS:T.Value,T.Qty,T.Price:T.Name="$1"} 

but it doesnt really list anything.

I havent had my coffee yet so I am not sure what I am missing


#2

Move the parameter under report name section them add T.Name to a column. Then do T.Qty.sum


#3
[$1 Tag Report:1,1,1,1]
@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum,T.Value,T.Price:T.Name="$1"}

Like this? Can listing even be under the [$1 Tag Report] ?:sweat_smile:
No effect, I am sure I am missing something very basic here…


#4

I’m not at a terminal but no remove the $1 in the name make it static. I’ll get to computer and test.


#5

Making the name static and putting $1 below lists the Order Tag Group Names correctly but it doesnt list its values nor quantities. :smile:


#6

the T.Name ="$1" is wrong. Remove that see what happens.


#7

Try this:

[Order Tag Report:1,1,1,1]
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum,T.Value,T.Price}

We can work on customizing it once we get it working.


#8
[Order Tag Report:3,1,2,1]
>Group Name|QTY|Tag|Price
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum,T.Value,T.Price}

#9

Or this will sort it descending from most tags to least.

[Order Tag Report:3,1,2,1]
>Group Name|QTY|Tag|Price
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum.desc,T.Value,T.Price}

#10

Yes, removing that works. This is what I get. Also, this is my database not my client’s so there isnt a lot of modifiers.

Works very similar. I just added .asc and $1

They show up properly but was was hoping I can group them by T.Name like sales report with ItemGroup.


#11

Oh so you mean like this:

@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:3,1,2,1]
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum.desc,T.Value,T.Price:(OT=$1)}

#12

Or actually this is better:

@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:1,2, 1]
{REPORT ORDER TAG DETAILS:T.Qty.sum.desc,T.Value,T.Price:(OT=$1)}

#13

Yes, thats exactly what I mean. However, they seem to “interfere” with one another. Because of Custom tags maybe? Could I use O.OrderTags != “Discount” to stop them form listing?


#14

You can try that and see.


#15

This was supposed to be easy haha…

Both as (OT!=“Discount”) and O.OrderTags != “Discount” dont work as a filter.

Or I am using them wrong.


#16

Weird im not sure why its showing others. It shouldnt.


#17

@emre can you explain this to me.

@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:1,2, 1]
{REPORT ORDER TAG DETAILS:T.Qty.sum,T.Value,T.Price:(OT=$1)}

I have that… it should return each tag under its tagname but its not acting correctly.

I made this report to demonstrate the issue:

@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:1,1,2, 1]
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum,T.Value,T.Price:(OT=$1)}

image


#18

Notice name on left… even though I used OT=X it still returned tags from other Tag Names.


#19

Yeah, funny that. I thought it was only mine because I was playing with custom tags the other day.

I wiped all the transactions and start new just to see if maybe something else influenced it. Still the same.


#20

Wait nm I see why… OT is not a real expression its a field. Give me a minute.