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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement