You were right, I was missing the '
char!!!
Thanks!!!
You were right, I was missing the '
char!!!
Thanks!!!
I added the $ in front of it so it would look like your report above it since it had the $.
where do you change colors?
THANK YOU VERY MUCH!!!
G.
You can’t right now. What I did was to a Pivot table using Design mode and Brushes… but it does not save them so its pointless. For now at least
Just thought I would be the 100th post on this topic! No really I am having fun with these features.
Ilike this post better, its 101… LOL!!!
guys, a little help here…
This (the filter part):
{REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,EN.Customer,EC.Customer.Phone,EC.Customer.Points,T.TotalAmount:(EN.customer<>'')}
is not working…
I tried all imaginable, EC, EN, EC.xxx, EN.xxx, EC.xxx.xx, EN.xxx.xx but allways te same error:
Thanks!!!
g.
That is wrong syntax for the expression.
{REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,EN.Customer,EC.Customer.Phone,EC.Customer.Points,T.TotalAmount:(X=X)}
(X=X) is the expression
I can’t tell by your syntax what are you wanting to display?
The way it works is everything before the : is the fields and the expression after the : tells it Fields of X so if you type
{REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,EN.Customer,EC.Customer.Phone,EC.Customer.Points,T.TotalAmount:(TEN.Customer=John)}
It will display Ticket Number, Ticket Date, Ticket Time, Customer Name, Customer PHone, Customer Points, Ticket Total for Entity John.
Or
{REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,EN.Customer,EC.Customer.Phone,EC.Customer.Points,T.TotalAmount:(TE=Terminal 1)}
Will display Ticket Number, Ticket Date, Ticket Time, Entity Customer Name, Entity Customer Phone, Entity Customer Points, Ticket Total for terminal 1.
Or
{REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,EN.Customer,EC.Customer.Phone,EC.Customer.Points,T.TotalAmount:(TEN.Customer=John) AND (TE=Terminal 1)}
Will display Ticket Number, Ticket Date, Ticket Time, Entity Customer Name, Entity Customer Phone, Entity Customer Points, Ticket Total for Entity Customer John and Terminal 1
Just a guess, but in a round-about way, @Jesse may have answered your question here:
(TEN.Customer=John)
So maybe try?
(TEN.customer<>'')
If your wanting it to list details for all customers on Terminal 1 then just leave out (TEN.Customer=John) expression… just put
{REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,EN.Customer,EC.Customer.Phone,EC.Customer.Points,T.TotalAmount:(TE=Terminal 1)}
Remember this is Ticket Details… so it requires an expression.
No that is wrong… the field EN.Customer already does this… he just needs to tell it a different expression like terminal #
He can put all terminals in it… like this (TE=Terminal 1) AND (TE=Terminal 2) AND (TE=Terminal 3) for example and not put an entity expression at all… then it will allow field EN.Customer to pull all customer entities for those terminals.
Or he can use department name it will show only for specific department… etc (DE=Pizzaria)
NO, the EN.Customer
does not filter records, just shows the customer if it has or blank if its not there…
I want to filter all records that do have something in EN.Customer
Thanks!!!
g.
@Jesse, this criteria:
(TEN.customer<>'')
is not the same as this criteria:
(TE=Terminal 1)
They will give you different results. I assume @gerlandog wants all tickets that have a Customer Entity, not all Tickets for a particular Terminal. Your suggestion will pull all Tickets, not just those that have or have not a Customer Entity.
The error indicates that EN
is not part of a Ticket, while perhaps TEN
is.
So try (TEN.Customer= ) there is a space after =
exact same error
No option to list all tickets that have a Customer Entity.
It seems that whenever an error occurs, it shows that xx is not part of a Ticket
…
Thanks!!!
G.
May need a different syntax than ticket details. We can to it just got to get it right.
EDIT try (TEN.Customers=Customer) I was reading the syntax wrong I think this should work.
Is it true that the only available operator is =
?
Would be nice if it supported most regular operators such as != , <> , > , < , >= , <=
, as well as LIKE
…
Yes that is true. That is how he built it. He mentioned that in a previous post. You can do (TEN.Customers=Customer) AND (TEN.Customers=VIP Customer)
or
(TEN.Customers=Customer) OR (TEN.Customers=VIP Customer)
An example he gave… This is not details tag but the expression syntax is same.
If all of your Customers have a <space>
in their name, would this work?
TENC.<entity type> Ticket Entity Name Contains
like:
(TENC.Customers= )
… contains a space
I really think (TEN.Customers=Customer) is what he is wanting. I will run some tests.
EDIT: Nope thats wrong… (TEN.Customer=Jason) works tho…