Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting Report Output
Message
 
 
To
29/06/1999 11:48:22
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00235298
Message ID:
00235633
Views:
21
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
Map
View

Click here to load this message in the networking platform