How to Convert existing report to Excel CSV

i am worried about report in excel, I need item sale report by Groups/Category like shown in picture.


its code is

@{REPORT ORDER DETAILS:O.ItemGroup.asc,O.ExactTotal.Sum::{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
[$1 Sales:8, 4, 2]
{REPORT ORDER DETAILS:O.MenuItemName,O.PortionName,O.Quantity.Sum.asc:(ODI=True) and (MG=$1)}
Total $1||{REPORT ORDER DETAILS:O.Quantity.Sum:(ODI=True) and (MG=$1)}

so experts please help to do it.

How are you worried? How does it come out in an export?

i want to know how can i take this report in excel.

Save the same code into a data export template, set a file name with directory samba has permissions to write to.
You probably need to set file type as CSV and adjust formatting on expressions to format data as csv.

Try searching the forum for examples like;

1 Like

I try it but result… you can see

Maybe you could try reading whole post…

1 Like