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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only