Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rene Relucio
  Where is Rene Relucio?
 Quezon City
 Philippines
 Rene Relucio
 To: yusito
  Where is yusito?
 Denpasar
 Indonesia
 yusito
 Tags
Subject: RE: How to apply the index in a report
Thread ID: 33943 Message ID: 34052 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Monday, December 08, 2003 4:12:01 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

USE myFile order myIndex

if using the dataenvironment
right click your table, Click properties, tab Data, and Order then select the index file.

Rene-PCSO


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