Data export help (+ Ticket note in report)

V5 Question
1

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)}
>Total||{REPORT TICKET DETAILS:TN.TotalAmount.Sum:(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)

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

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

Thanks before!

2

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.

REPORT
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}"}
3

Dear @kendash,

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

Best,
Kelvin

4

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

5

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:

REPORT
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}"}
6

Hahahaha!!

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
7

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

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

1 Like
8

Got it… Thanks @kendash

9

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}"}

note1
note1776×298 8.8 KB

r

10

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

11

changed but not displaying dataNOTE 2

12

to display this

3
3835×509 56 KB

13

[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}"}

14

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
15

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

16

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

image

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}"}

image
image991×196 9.1 KB

image

17

thanks alot working how about to and a table number column

18

You need to use tag EN.xyz

EN.Table