0

Sort by Countunique Result

Jet Reports Historic Posts

May 19, 2010 12:16

None

Follow

Hi, is it possible to sort a JetReport by the result from a 'Countunique' formula?
I am trying to run a report to show the number of items per vendor, in descending order of the number of items. The formula I am using is:
=NL("Countunique","Item","No.","Vendor No.","@@"&$G38,"Catalogue Item","Yes","Drop Ship Only","No")
Thanks

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts May 20, 2010 21:39

  Hello,
  
  You would need to add what is called a "CalcFilter" to your NL function in cell G38. Since it is the formula that is listing Vendor numbers, that is where the sort must be applied. It would look something like this:
  
  =NL("Rows","Item","Vendor No.","-=NL(""CountUnique"",""Item"",""No."",""Vendor No."",NF(,""Vendor No.""),""Catalogue Item"",""Yes"",""Drop Ship Only"",""No"")","*","Catalogue Item","Yes","Drop Ship Only","No")
  This will sort the Vendor numbers by the result of the NL(CountUnique). The NF without a record key, inside the embedded function, is referring to the "current record" from the outermost NL. These things take some practice, but once you get the hang of it they can be really powerful. Hope this helps.
  
  Regards,