Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: yusito
  Where is yusito?
 Denpasar
 Indonesia
 yusito
 To: Chan Kok Kiet
  Where is Chan Kok Kiet?
 Kuala Lumpur
 Malaysia
 Chan Kok Kiet
 Tags
Subject: How to apply the index in a report
Thread ID: 33943 Message ID: 34049 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Monday, December 08, 2003 2:12:21 AM         
   


> Hi,
> Try
> INDEX ON RIGHT(myField, 3) TAG myIndex
> SET ORDER TO myINdex
>
> > I have a field that contains combination character and numeric expression like this
> > A003
> > U001
> > H004
> > S002
> > I want that sort the record according to the last 3 digit (numeric expression), as below
> > U001
> > S002
> > A003
> > H004
> > How can I do that ?
> >
> > Al Walaad
>
>
> I am not the most powerful man in this world.
> I am not the worst man in this world either.
> I just as same as all of you.
> I still need to learn from my mistakes...

Thank you, It workes in a form but how to apply it in a report. I mean to sort the report using the index.

Al Walaad

ENTIRE THREAD

HOW TO SORT RECORD ACCORDING TO A FIELD Posted by Al Walaad @ 12/5/2003 10:21:22 AM
RE: HOW TO SORT RECORD ACCORDING TO A FIELD Posted by Chan Kok Kiet @ 12/5/2003 3:26:18 PM
How to apply the index in a report Posted by Al Walaad @ 12/8/2003 2:12:21 AM
RE: How to apply the index in a report Posted by Rene Relucio @ 12/8/2003 4:12:01 AM