Data export help (+ Ticket note in report)

Hi all,

i’m creating a basic report that listed all the sales on the specific entities during the day.
Here’s the report code.

[Gojek Order Details:2, 1, 2, 2]
{REPORT TICKET DETAILS:T.Date,T.TicketNumber,T.Time,TN.TotalAmount:(TCET=PATIO)}

I’m trying to put that code on the Data Export, so i can export it to CSV and open it in Excel.

On the other hand, i want to put Ticket Date & Ticket Note on the code as well, but i can’t find it in the fields in here Custom Report Tags in detail

Here’s what i can think of so far… (And it doesn’t work)

    Ticket Date;Ticket Number;Ticket Time;Total Amount

Any ideas how i can fix the code & add ticket note guys?

Thanks before!

Try T.Note for ticket note.

I think you need to wait for 5.1.54 to use formatting like that so until that releases try this all in one line.

Ticket Date;Ticket Number;Ticket Time;Total Amount;Ticket Note
{REPORT TICKET DETAILS:<row>,T.Date,T.TicketNumber,T.Time,TN.TotalAmount,T.Note,:(TCET=PATIO):"{0}";"{1}";"{2}";"{3}";"{4}";"{5}"}

Dear @kendash,

Thanks a lot! It works like a charm…
But the T.Note is not working, maybe it’s not implemented yet?


It is implemented. You sure you had Ticket Notes for those Entities?

HAHA I see what problem is. We are not listing it. <row>, counts as {0} So we need to add {5} at end. try this:

Number;Ticket Date;Ticket Number;Ticket Time;Total Amount;Ticket Note
{REPORT TICKET DETAILS:<row>,T.Date,T.TicketNumber,T.Time,TN.TotalAmount,T.Note:(TCET=PATIO):"{0}";"{1}";"{2}";"{3}";"{4}";"{5}"}


I noticed that the produced a number to the report, so i added Number;Ticket Date
But i forgot to add the {5} at the end… hahahaha… =D

Thanks a lot kendash!
It’s perfect!

1 Like

If you do not want that number you can simply remove <row>,

<row> prints the row number. Its useful for Excel

1 Like

Got it… Thanks @kendash

Hello . this is not display on report
Number;Ticket Date;Ticket Number;Ticket Time;Total Amount;Ticket Note
{REPORT TICKET DETAILS:,T.Date,T.TicketNumber,T.Time,TN.TotalAmount,T.Note:(TCET=PATIO):"{0}";"{1}";"{2}";"{3}";"{4}";"{5}"}


That is invalid syntax. You can not use semi colon like that.

changed but not displaying dataNOTE 2

to display this

[Ticke1t Note:6,6,3,5,4,4]
Number|Ticket Date|Ticket Number|Ticket Time|Total Amount|Ticket Note
{REPORT TICKET DETAILS:,T.Date,T.TicketNumber,T.Time,TN.TotalAmount,T.Note:(TCET=PATIO):"{0}";"{1}";"{2}";"{3}";"{4}";"{5}"}

You need to define your fields as well also are you sure TCET=PATIO is correct? Is it actually PATIO and not Patio or patio?

Do you actually have one called PATIO?

1 Like

TCET=PATIO i dont have it. Which field is it

Its the name of your Entity Type.

As far as I can see you have:

  • Table
  • Coffe Bar
  • Table’

So (TCET=Table) or whatever other entity types you want to list.

That ' could cause you some issues, its best to leave characters like , . / | \ ; : ’ " out of any product/entity names.

Something along the line of:

[Ticket Details:1,1,1,1,2]
>>Date|Time|Ticket No|Total|Note
{REPORT TICKET DETAILS:T.Date,T.Time,T.TicketNumber,T.TotalAmount,T.Note:(TCET=Table)}


For export you would put it like this:

Date,Time,Ticket No,Total,Note
{REPORT TICKET DETAILS:T.Date,T.Time,T.TicketNumber,T.TotalAmount,T.Note:(TCET=Table):"{0}","{1}","{2}","{3}","{4}"}


thanks alot working how about to and a table number column

You need to use tag