Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sorting Report Output
Message
 
À
29/06/1999 11:48:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00235298
Message ID:
00235633
Vues:
22
The safest option is to use SQL to put your data into a cursor that you can sort. Then run the report on that cursor.

SELECT id, HdaSort FROM JeffTable ORDER BY id, HdaSort INTO CURSOR cReport
REPORT FORM JeffReport NOCONSOLE TO PRINTER PROMPT

In the report make grouping by id.

>I am using a table that has and ID field and HdASort field. I am attempting to get the following resulst:
>
>Vacc A
>555-5555-55555
>666-6666-66666
>
>Vacc B
>888-8888-88888
>
>But instead I'm getting
>
>Vacc A
>555-5555-55555
>
>Vacc B
>888-88888-88888
>
>Vacc A 666-66666-6666
>
>I tried working around it by using an sort field and order by sort number Vacc A being highest Vacc D being lowest but that only gives me multiple sheets everytime the id changes.
>
>Jeff T.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform