How to Convert existing report to Excel CSV

[wattoo.biz]

Hi,
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.

[JTRTech]

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

[wattoo.biz]

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

[JTRTech]

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;

Data Exports and Parameters?

Hi @emre Can we use Parameter Lists in Data Exports like so: [image] Currently it fails or I have something wrong? Note: See the use of (PA=$1) in the Tag Line.

[wattoo.biz]

@wattoo.biz

@{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)}

I try it but result… you can see

[JTRTech]

@JTRTech

You probably need to set file type as CSV and adjust formatting on expressions to format data as csv.

Maybe you could try reading whole post…