I think that is a bug of VFP 5.0. When you print qith the icon it doesn´t consider the for clause. It is corrected in VFP 5.0a.

Juan P. Pérez

>>Nick, thanx for your help.
>>
>>this is the syntax:
>>
>>select invoice_detail
>>report form invoice for invoice_detail.invoice_no = invoice_header.invoice_no preview
>>(I do not use a report data session, all files are already open)
>>
>>It work O.K. onthe preview but when I print it it print all of the detail lines from the detail DBF.
>>
>>
>>
>>>>Has some one had this happened to you?
>>>>
>>>>I have an invoice report with header and detail
>>>>
>>>>If I print invoice #1000 to preview, everything works well, I can see the header of the invoice and only the detail lines pertaining to that invoice. (1000)
>>>>
>>>>But as soon as I send it to print (via the icon bar) all hell breaks loose! VFP5.0 prints the invoice header and the WHOLE RECORDS IN THE DETAIL DBF.
>>>>
>>>>Does any one know why? can some one help on how to fix this?
>>>
>>>What is exact syntax of your REPORT FORM code line?
>Is it possible that you have a relationship set between the header and detail tables? To verify that you do not try the report after adding the line "SET RELA TO"