>I am trying to do a report that has one parent table and two related child tables.
>Each child table has numeric columns that need to be formatted properly in the report.
>After printing some page header information, I need to list all of the records from child table 1, then with completely different headings, print the records from child table 2.
>This seems like a very common task but I'm not having any luck. I am using SQL 2000 on the back end and pass one cursor file to my report handling routine. Any ideas would be appreciated.

Another alternative would be to index the child table on the field that references the records in the parent table, then establish the relation and SET SKIP TO (child table name). Or use Access or Cystal Reports. We all know the shortcomings of the Foxpro report writer, which is the same as it was 10 years ago. MS and Bill obviously do not want to upgrade it. There is not as much revenue generated when you have one product that does everything.
But I would rather live with a weak report writer than a weak application with a great report writer.