>Hi Jim,
>
>I agree 100%, I am using a view that groups and sorts the data before vfp gets a hold of it. But the view is the data environment. How do I run a report from code?

Let's assume you have a report that lists clients, and that you already erased any table from the report's DataEnvironment.

A sample might be:

select ClientCode, ClientName, CurrentDebt;
  from Client;
  order by CurrentDebt descending;
  into cursor Temp
* Preview:
report form SimpleClientList preview
* Print:
report form SimpleClientList to printer prompt

Or do you need anything else?

Hilmar.