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.