Adam,

If your report references MyTable.MyField and MyTable is not current the report will print for only the record in MyTable where the record pointer is, while it scrolls through the current table, which I suspect has only one record.

Do you SELECT INTO TABLE tmpData or CURSOR tmpData? How does it know the second time around to use tmpData instead of SELECTing new data?

Maybe post some of your code?


>Thanks Cindy
>
>I have done some things similar already. Having STEP ON, and inserting the BROWSE statement after each SQL statement. The correct data sets appear, at least the first time through prior to the PREVIEW, and the correct data does appear in the PREVIEW. Apparently, when you click on the PRINT icon, VFP runs some of the code a second time, but the BROWSE doesn't come up to check the data. I also have the 'USE tmpData' in the INIT of the report form, and if the form is being run twice, you would expect it would be identical.
>
>The strange thing about this is that if there is only ONE record in the Detail, the PREVIEW & PRINT work AOK. It's only when there are multiple records that all but one get dropped.
>
>I will try to use your suggestion with the breakpoint.
>
>Adam