Need help in excel export

V5 Question
1 
[Orders by Officer:2, 1, 1]
>Item|Quantity|Total
@Free
>>Orders by $1
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum,O.ExactTotal.Sum:(TEN.Officer=$1)}
>$1 Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(TEN.Officer=$1)}

that is my main as report whe i change to export with csv i change to

Index,Item,Quantity,Total
{REPORT ORDER DETAILS:
<row>,
O.MenuItemName,
O.Quantity.Sum,
O.ExactTotal.Sum,
:(TEN.Officer=$1)
:"{0}","{1}","{2}","{3}"}

how i can add name ??

i don’t know how to convert

@Free
>Orders by $1

to be export with excel

any help ?

2

Sorry couldn’t understand what you’re asking here.

Better show some screenshots of what it actually exports and what you expect it to report so we can understand what you want to convert, what @Free is or what you want to do in general.

3

[Orders by Officer:2, 1, 1]

Item|Quantity|Total
@free

Orders by $1
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum,O.ExactTotal.Sum:(TEN.Officer=$1)}
$1 Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(TEN.Officer=$1)}

i created new entity called officer and named it with my employees name , and created new ticket called officer.
tho that report show me every item ordered on those table with table name ,
the [quote=“a.samy, post:1, topic:8233”]
@Free
>Orders by $1
[/quote]

is one of those entities , tho in report it tell me free have how many item ordered and what on this table

4

i want to switch to excel export sheet

5

Its not the solution your asking for but I thought I should point out if your using a single Entity then there is no reason to use Template format. I mean just directly put it in the report like this:

[Orders by Officer:2, 1, 1]
>Item|Quantity|Total
>>Orders by Free
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum,O.ExactTotal.Sum:(TEN.Officer=Free)}
>Free Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(TEN.Officer=Free)}

Templating is useful if you have multiple values after the @ separated by comma so in your case its only useful if you list multiple Entities. If your reporting on single value then just directly put it in the report instead of using Template.

Now your Excel report looks like this:

[Orders by Officer:2, 1, 1]
Index,Item,Quantity,Total
{REPORT ORDER DETAILS:
<row>,
O.MenuItemName,
O.Quantity.Sum,
O.ExactTotal.Sum,
:(TEN.Officer=Free)
:"{0}","{1}","{2}","{3}"}
1 Like
6

and if it’s like that ?

7

LOL thats not what you showed us.

8

lol , i said [quote=“a.samy, post:3, topic:8233”]
i created new entity called officer and named it with my employees name , and created new ticket called officer.tho that report show me every item ordered on those table with table name , the
[/quote]
employees :smiley:

9

but sorry for that misunderstanding , can u help me in that ?

10

Try this:

[Orders by Officer:2, 1, 1]
Item;Quantity;Total
@Free,Ahmed,Mohamed,Owner,Stuff
Orders by $1
{REPORT ORDER DETAILS:
O.MenuItemName,
O.Quantity.Sum,
O.ExactTotal.Sum,
:(TEN.Officer=$1)
:"{0}","{1}","{2}","{3}"}
"$1 Total";;;;=SUM(F<row-{REPORT ORDER DETAILS:O.ExactTotal:(TEN.Officer=$1)}>:F<row-1>)

PS: I have not tested that but it should work I hope.

1 Like