>>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?
>>
>>Thanx in advance
>>
>>Alfred.
>
>Hi Alfred,
>
>Just a real quick thought, but it sounds as if whatever you are using to hold the invoice # has lost scope when you use the toolbar to print. I'd check there first.
>
>Steve Despres

This is a known bug in VFP 5.0 where reports using 'for' print all records on the DB. It is fixed in 5.0a or you can use 'set filter' to limit the records.

Steve