You might also consider how simplistic the ranking system is.

A more meaningful ranking might be to get the total $ sales of all customers,
then into the ranking field put what percentage of that is this particular
customer's sales.

I have done reports in which the customer data is sorted from high $ going on
down, and then we only print the first couple pages.  If done via RPG, you
can have the program track how often new page is tripped & then end the
program execution after a selected number of pages, so you don't eat 400
resource generating the part of the report we are not going to need.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.