General information
Category:
Coding, syntax & commands
>>>>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?
>
>>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.
>
>I think what Dave Emerson says is the solution, I haven't met this problem, because I always try to create the cursor with the SELECT .... WHERE... statement and run report on that cursor.
>
>Nick
Nick,
I agree. I finding more and more that using cursors for reports solves problems before they hit you in the face.
Dave
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only