John,

The absolute best way to do a report is to select the data for your report into 1 non-normalized cursor and print from there. That would mean that you would have both the parent data (which would be repeated) and the child data in one cursor. Then set up your report with the fieldname only in the controls, not Table.Field.

You won't have to create the index or SET SKIP this way either.



>Hi everyone,
>
>I'm having trouble figuring out why one of my 1 to many reports is not printing correctly. Here the situation:
>
>I create two cursors, the first to get parent records, and second to get child records. I then create an index on the child cursor to allow me to relate to the parent cursor and set skip to etc. the parent cursor looks fine after this is done. Then if I preview the report with that cursor all looks perfect as well, but when I use
>REPORT FORM myreport.frx TO PRINTER NOCONSOLE, only the first record (and sometimes part of the second record) prints on the report when there should be 30 records on approx. 5 pages. I dont understand why it previews fine but when I print it only show a couple of records. I vaguely remember problems like this happening when the PROMPT command was used, but I need to make sure this report goes to a specific printer and tray (special paper issue) so I am not using PROMPT. If anyone has any ideas I sure would like to hear from you.
>
>Thanks :-)
>
>John.