>Thanks for the reply. I know how to do the automation to word or excel as I do that all of the time at work. But for this app I can not be sure that the user will have word and do not want that to be a requirement. I will try your work around and if I don't get it working I may look into crystal reports.
>
>Thanks
>Earl

Another option I mentioned is HTML. I am quite sure you can count on that (at least, free browsers are available). The difficulty I see here is actually printing the report. I think it can be done with Internet Explorer, which exposes an object model. Personally, however, I only use HTML for report preview (for reports in text-mode).

The conditional printing with VFP reports (with one or more lines in the detail band, one for each "sub-report") might be the simplest solution, after all. But I wanted to explore different alternatives.

For this multiple-detail report, you first have to create a cursor that combines all the required data, vertically (SELECT ... UNION). An additional field indicates to what "sub-report" the data belongs. I think this is explained in more detail, somewhere in the FAQ.