Customer by sale ranking

V5 Question
1

This is a sales ranking report… I dont remember who was looking for something like this…

this is working except that the order is by name and not by sales amount (I dont think this can be done this way).

@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Customers):{0}:,}

[Facturado por Cliente:2,2,2, 2]

>Cliente|Direccion|Barrio|Facturado

{REPORT TICKET DETAILS:EN.Customers,EC.Customers.Address,EC.Customers.Bairro,T.TotalAmount.Sum:(TEN.Customer=$1)}

I someone can modify it would be perfect…

Thanks!!!

G.

2 
T.TotalAmount.Sum.desc

Try that?

3

yes, was the first think to try… but… each line is a report, so the .ASC or .DSC wont work…

LOL

G.

4

Ok so why are you feeding in a parameter list? Can you use that expression (ET=Customers) as part of the main Report Tag?

I use this:

{REPORT ORDER DETAILS:EC.Customer.Full Name,O.ExactTotal.sum.desc:(ODI=True) && (TCET=Customers):{0}|${1}}

Note: You may not have custom field Full Name…

5

I did not do it that way becuase…

I did not know I could do that…

PPPPPPRRRRRRRRRRRRRRRR

SHOW OFF

G.

I dont have a full name, but I do have a Name as primary field:

Pasted image1366×768 37.5 KB

Pasted image1366×768 38.5 KB

but I dont seem to find how to show it…

6

Try E.Name to show primary?

7

E.Name does not work…

tried everything I could think…

Pasted image1280×800 33.6 KB

thanks

G.

8

This is from “Custom Report Tags” Tutorial V4:
EN.<entity type> Entity Name

Just saw you are using REPORT TICKET DETAILS:x So your original syntax should work?

9

I am using your ta:

{REPORT ORDER DETAILS:EC.Customers.Bairro,O.ExactTotal.sum.desc:(ODI=True) && (TCET=Customers):{0}|${1}}

and this works…

G.

10

so…
In REPORT ORDER DETAILS I can extract Entity Custom Data, but I cannot get to extract primary field…

What I am missing here?

Thanks!!!

g.

11

Now you know the rules 'Dog, can’t help if you don’t show your syntax attempt? :grin:

12

so… you did not look one post above? LOL!!! this time: GOTCHA!!!

G.

13

haha I could argue that you did not highlight the syntax using "</>" but that would just be an excuse!
But seriously you may have a point I need to barlese here.

Since I use EC.Customer.Full Name (Custom Field) it has the benefit of not requiring Entity Name.

14

I I edit the post and use the "</>" would it count??

jajajajajaja

thanks!!!

G.

15

Nup, don’t have an answer we have to refer it onto the umpires to see if they can help you :smile:

16

umpires?? vampires??

G

17

The higher powers that know way more than me like Q, Kendash and the big E…

18

Sorry to bother you @Emre, is there any chance we can access Customer primary field form within this report?

{REPORT ORDER DETAILS:EC.Customers.Bairro,O.ExactTotal.sum.desc:(ODI=True) && (TCET=Customers):{0}|${1}}

I can access Customers Custom data witohou any problems…

Thanks!!!
G.

19

EN.Entity Type will give you the Primary field. So EN.Customers

20

I think he means Formatted Entity Name as defined by Primary Field Format setting of Entity Type.

I added EFN.<entity type name> field for it. It will work fine on 5.1.61.