Sort based on count

Jet Reports Historic Posts

December 03, 2013 09:11

None

Hi
I'm making a report were I cont how many invoices we have got from varies vendors. The list i get out is sort bye vendor nr. I want it to be sort by numbers of invoices.
=NL("count";"ES_TRANS_HEADER";;"Reg. date";$E$4;"Company";$G$12;"Vendor";G14)

Date Votes

1 comment

0

Jet Reports Historic Posts December 03, 2013 16:25

Hi,

It looks like you're using a Universal data source. In this case, I think the only way to achieve this would be to use the SQL= functionality of Jet and create a SQL query. You can see more about SQL= here: http://help.jetreports.com/14.0/Essentials/index.html?SQL=.html

Regards,
Hughes

Comment actions Permalink

Please sign in to leave a comment.