Table revenue report sum, tables repeating itself over again

Good day guys, am facing difficult trying to get an accurate table report. My client wants to see the revenue for all the tables in the lounge. eg.
Table 1 = 30000
Table 2= 50000
but after reading through all table topics i was able to create a table report but the tables keep surfacing and repeating it self. here is the image


please i need help i have tried to fix it my self but know solution.
thanks you
here is my code aswell

[TABLE REPORT:3,2,2,2,2]
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 1)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 2)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 3)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 4)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 5)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 6)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 7)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 8)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 9)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 10)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 11)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 12)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 14)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 15)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 16)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 17)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 18)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 19)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 20)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 21)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 22)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 30)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 31)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 32)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 33)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 34)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 35)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 36)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 37)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 38)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 39)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 40)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 41)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 45)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 46)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 47)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 50)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 51)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 52)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 53)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 54)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 55)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 60)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 61)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 62)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 63)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 64)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 65)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 66)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 67)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 68)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 69)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 70)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 71)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 72)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 73)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 74)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 75)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 76)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 77)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 78)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 79)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 80)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 100)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 101)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 102)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 103)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 104)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 105)}`

Did you create that for each table that you have? You can do a single report tag and remove each filter

Ok. If I do a single tag, it might keep repeating Itself again. But will still try it out…

[TABLE REPORT:3,2,2,2,2]
@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Table):,}
{REPORT TICKET DETAILS:EN.Table,T.TotalAmount.sum:(TENC.Table=$1)}
4 Likes

Please Mr Jesse any solution i have being on this report for a month now.

i tried it this is what displays, unending report generation, never stop.

[TABLE REPORT:3,2,2,2,2]
@{REPORT ENTITY DEATILS:E.Name.asc:(ET=Table):,}
{REPORT TICKET DETAILS:EN.Table,T.TotalAmount.sum:(TENC.Table=$1)}
[TABLE REPORT:3, 2]
@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Table):,}
{REPORT TICKET DETAILS:EN.Table,T.TotalAmount.sum:(TENC.Table=$1)}

image

[!TABLE REPORT:1,3, 1, 2:0]
>[I]ID|Table|[N]Count|[C]Total
@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Table):,}
{REPORT TICKET DETAILS:T.Id,EN.Table,EN.Table.Count,T.TotalAmount:(TENC.Table=$1)}

Table_Report_YILDIZHANPOS_WP_+905393035863.zip (1.6 KB)

TR

Üstteki zip dosyasını yükleyin.
Bu kısım üsteki raporun içini silip ekleyiniz

[!TABLE REPORT:1,3, 1, 2:0]
>ID|Table|[N]Count|[C]Total
@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Masa):,}
{REPORT TICKET DETAILS:T.Id,EN.Masa,EN.Masa.Count,T.TotalAmount,T.Time,T.User,T.Terminal:(TENC.Masa=$1):#{0}  🕒{4}  👲🏽{5}  🖥️{6}|{1}|{2}|{3}}

EN

Download the zip file above.
This part delete the inside of the above report and add it

[!TABLE REPORT:1,3, 1, 2:0]
>ID|Table|[N]Count|[C]Total
@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Table):,}
{REPORT TICKET DETAILS:T.Id,EN.Table,EN.Table.Count,T.TotalAmount,T.Time,T.User,T.Terminal:(TENC.Table=$1):#{0}  🕒{4}  👲🏽{5}  🖥️{6}|{1}|{2}|{3}}
2 Likes

thank you ilyas. for your time and support. i tried it still the same thing but i realised that the cause of repeation was Table 1, Table 2, Table 3, Table 4, Table 5, Table 6 …Table 10. they seems to mess up report by causing repeation amounts in the table. for instance from the image above Table 100 with the total Amount of N25,000 keep repeating, that was as a result of these syntax below

{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 1)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 2)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 3)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 4)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 5)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 6)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 7)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 8)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 9)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 10)}

if the table number can begin with Table 11 or just 11 and beyond all the Table reports are very ok.

Here is my syntax after removing Table 1 - 10 or table number 1 - 10 my report seems to be accurate

[TABLE REPORT:3,2,2,2,2]
@11,12,13,14,15,16,17,18,19,20,21,22,30,31,32,33,34,35,36,37,38,39,40,41,45,46,47,50,51,52,53,54,55,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,100,101,102,103,104,105,Void
@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Table):,}
{REPORT TICKET DETAILS:EN.Table,T.TotalAmount.sum:(TENC.Table=$1)}

then for my grand table total for all table sections here is my syntax

[BAR TABLES:3,2,2,2,2]
@40,41,42,43,44
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 40)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 41)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 42)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 43)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 44)}
[BAR TOTAL:3, 2,2,2,2]
>>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) AND ( (TENC.Table=Table 40) OR (TENC.Table=Table 41) OR (TENC.Table=Table 42) OR (TENC.Table=Table 43) OR (TENC.Table=Table 44) ) }



[BOAT TABLES:3,2,2,2,2]
@15,16,17,18,19,20,21,22
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 15)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 16)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 17)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 18)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 19)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 20)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 21)}
{REPORT TICKET DETAILS:EN.Table,EN.Table.asc,T.TotalAmount.sum:(TENC.Table=Table 22)}
[BOAT TOTAL:3, 2,2,2,2]
>>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) AND ( (TENC.Table=Table 15) OR (TENC.Table=Table 16) OR (TENC.Table=Table 17) OR (TENC.Table=Table 18) OR (TENC.Table=Table 19) OR (TENC.Table=Table 20) OR (TENC.Table=Table 21) OR (TENC.Table=Table 22) ) }

thanks everyone for helping me out
thanks ilyas. i appreciate

1 Like

— This is just a suggestion —
If your client is concerned about keeping track of figures for each section/area and tables, you could add a custom field to the Tables Entity and fill in each table custom field with the appropriate section/area (Boat Tables, VIP Tables, . Then you run the below report to fill to list each section/area as the sales happen, if there is no sales in the section/area, it will not show up.

[Table Report:1, 1, 1]
>Table|Count|Amount
@{REPORT TICKET DETAILS:EC.Tables.Section:(TCET=Tables)::,}
>>   $1 Section
{REPORT TICKET DETAILS:EN.Tables.asc,EN.Tables.count,T.TotalAmount.sum:(TEC.Tables.Section=$1)}
>   $1 Total:|{REPORT TICKET DETAILS:EN.Tables.count,T.TotalAmount.sum:(TEC.Tables.Section=$1)}
>>Total:|{REPORT TICKET DETAILS:EN.Tables.count,T.TotalAmount.sum:(TCET=Tables)}

The total below is not correct because I had some sales before testing the Tables Custom Fields. It will only show sales after implementing the custom fields.

still didnt work… i repeated same code you posted on a fresh database on my Pc and it didnt work.

{REPORT ENTITY DETAILS:E.Name.distinct:(ET=Table)}

Screenshot

Sorry, I forgot to mention it would only work going forward. It will not work with existing data.

You will have to add a custom field to your Tables Entity.

Then update each table to the section:
nzjjBZ46Eu