Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sorting Detail Items (again)
Message
 
À
04/09/1997 09:48:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00048475
Message ID:
00048647
Vues:
19
>I am still having trouble sorting the detail items on a one-to-many report. The only suggestion given a few weeks ago when I posted the question was to set the order of the cursor in the dataenvironment, which I have done. It doesn't do a darn thing. Has anybody actually tried this and it works? If not, how do I do this? As seems to be par for the course in learning VFP features and quirks, the documentation is of no help. I must find a way to do this, please help. Thanks
>
>Erik
Erik,

The first hing you need is an index that will both support hte relationship and give you the order you want. Let's assume the table is name dChild and its key for the relatioship is a field named ParentId (Character) and you want the recor din order by the EntryDate field (Date), you need an index like this one;

USE Child
INDEX ON ParentId + DTOS(EntryDate) TAG ReportOrder

Now set the order for the table, in the report's DE to ReportOrder and set the realtionship from Parent to Child and set the OneToMany property to .T.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform