THANK YOU (I knew it was a senior moment)
On Tue, Jul 15, 2008 at 6:50 PM, Gérard Lochon <[EMAIL PROTECTED]> wrote: > > I have a table which amongst other things has a field called salespers > and > > salesrev > > I want to print the report in salesperson order, then salesrevenue > > The sales person gose from 1 to 999 > > How do I sort or index this table so that salespeople go from 1 to 999 > but > > sales from highest to lowest > > > > > A) Assuming m.lx is the width of salespers and m.ly is the width of > salesrev : > > INDEX ON PADL (10**m.lx-salespers,m.lx)+PADL(salesrev,m.ly) DESCENDING TAG > yourtag > > (In your example, m.lx = 3 and probably m.ly = 9) > > B) Why create an index for a report ? > > You better select the right set in the right way, like : > > SELECT salespers, salesrev FROM yourtable ; > ORDER BY salespers ASC, salesrev DESC ; > INTO CURSOR yourresultset > > Gérard. > > > > > ____________ > Analysé par G DATA AVK > Version : AVK 18.4496 de 15.07.2008 > Informations sur les virus : www.antiviruslab.com > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
