Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to make a TOP10-Report?
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00359892
Message ID:
00359948
Views:
15
Stefan,
Make a cursor using the TOP nn clause. Here's the example from Help:

SELECT TOP 10 *;
FROM testdata!customer INNER JOIN testdata!orders ;
ON Customer.cust_id = Orders.cust_id;
GROUP BY Customer.cust_id;
ORDER BY Orders.order_amt DESC

HTH
Barbara


>Hi everybody,
>
>I know there are many solutions to creates TOP10-Reports and/or graphs. I saw them, I read them, print them out and someday they were lost - I don't know where.
>
>So, can somebody give me a hint?
>
>Sorry about my english,
>
>Stefan
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform