Data Exports feature

V5 Question
12

I’m trying to export daily sales totals by date to CSV, using the report template taken from Sales Report monthly with just a few modifications to suit my setup and support CSV output.

Here is the template:

Date,TicketSales,Discount,Total,Cash,Visa,Master,Amex,UnionPay
{REPORT TICKET DETAILS:
	T.Date,
	([T.TotalAmount]-[CA.Discount]-[T.Tax]).sum,
	CA.Discount.sum,
	T.TotalAmount.sum,
	PA.Cash.sum,
	PA.Visa.sum,
	PA.Master.sum,
	PA.Amex.sum,
	PA.UnionPay.sum
:(TS.Status=Paid)
:"{0}","{1}","{2}","{3}","{4}","{5}","{6}","{7}","{8}"}

It is just exporting the header tow and the data is all blank:

Any ideas? Have I got the syntax wrong?