Alfred,

This is a bug in 5.0 which was fixed in 5.0a. The print routine ignored any filter or for settings and used the entire table. 5.0a recognized any settings for the preview. I had the same problem which was immediately solved by 5.0a.

Dave

>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?