I am using this report tag to display waitress names on entity buttons but I think its causing slowdowns when there are multiple tickets in a table. I am trying to find somewhere on the forum on how to manipulate this to only show one “Administrator” instead of 3 but having trouble finding something similar. Any advice or previous post links with any help is greatly appreciated.
{REPORT TICKET DETAILS:T.User:(TEN.Table=12) and T.RemainingAmount>0}
I dont think consolodating to single listing of Administrator in that example would have any performace effect…
Using report tags on entity buttons will cause slowdown if you have many buttons. Emre has warned about that many times.
I also wanted to fix it for aesthetic purposes. When they split the ticket it tries to squeeze all those inside a entity button so the font size gets really small. If someone knows how it would also be really helpful for one of my implementations for positions that im starting to work on again.
Id like it to choose the last value in the return. For positions I get a report output of (1,2,3,4,5) I want to only the 5 (or another last comma separated value ex 6,7, or 8) I am attempting to track beverages on a ticket to make sure there is at least one drink in the ticket per position.
If nothing else you could feed into a script, parse list and return.
I was thinking for sure I could do it with sql reports? I unfortunately have never used sql query language and dont know where to start.
How many entities? It doeasnt sound very efficient to do queries like that every time screen refreshes for each button.
21 tables! Yeah your right it doesn’t make much sense. Speed is priority for us. Bummer, thanks anyways guys.